CloverETL Transform Language

xsvov1@seznam.cz

• August 03, 2007 00:00

• Answered

Follow

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);

• 

  dpavlis

  • August 03, 2007 16:14

  0

  Comment actions Permalink

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

Please sign in to leave a comment.