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