# CloverETL Transform Language

**URL:** <https://forum.cloverdx.com/t/cloveretl-transform-language/204>\
**Category:** CloverDX Platform\
**Created:** [August 3, 2007, 12:00am UTC](https://forum.cloverdx.com/t/cloveretl-transform-language/204 "2007-08-03T00:00:00Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![xsvov1seznam.cz](https://avatars.discourse-cdn.com/v4/letter/x/c6cbf5/32.png) [@xsvov1seznam.cz](https://forum.cloverdx.com/u/xsvov1seznam.cz)\
**Post date:** [August 3, 2007, 12:00am UTC](https://forum.cloverdx.com/t/cloveretl-transform-language/204/1 "2007-08-03T00:00:00Z")

</div>

Hi,

I can ask question how I can Transformation Language in transformation.

LookupJoin

I can do it for exaple this in transformation.

${out.0.OrderID} = ${in.0.OrderID};  
${out.0.CustomerID} = ${in.0.CustomerID};  
${out.0.EmployeeID} = ${in.0.EmployeeID};  
${out.0.EmployeeID2} = lookup(employee,${in.1.EmployeeID}.employee\_ID);  
${out.0.LastName} = lookup(employee,${in.1.full\_name}.employee\_ID);

this is your exaple in ETL Transformation Language on the webside

print\_err(lookup(LKP,’ HELLO ').Age);  
print\_err(lookup\_found(LKP));  
print\_err(lookup\_next(LKP).Age);

---

<div class="post-metadata">

**Author:** ![dpavlis](https://avatars.discourse-cdn.com/v4/letter/d/90ced4/32.png) [@dpavlis](https://forum.cloverdx.com/u/dpavlis)\
**Post date:** [August 3, 2007, 4:14pm UTC](https://forum.cloverdx.com/t/cloveretl-transform-language/204/2 "2007-08-03T16:14:34Z")

</div>

Hi !

Your post has been answered in clover.support forum. Please, don’t post your question several times into different forums next time !

David.