ETL and Data Integration tools - Modern ETL software for everyone

Hi,

I am evaluating Advanced ETL Processor Ent for our Data Loading functionality. Got a query while loading Excel data to MySQL.

Source excel has a column SYSTEMNO, which shoule be transformed as EMPLOYEE_ID and mapped to DB Column EMPLOYEE_ID. I need to translate SYSTEMNO as EMPLOYEE_ID using a query SELECT EMPLOYEE_ID FROM EMPLOYEE WHERE SYSTEMNO=''.

I think, this logic should be implemented in the transformation process. But, struggling to find the right transformation function to do this. Any pointer to overcome this issue is very much appreciated.

Thanks & Regards,
Syed.

Found a tutorial for you

www.dbsoftlab.com/online-tutorials/advan...g-lookup-object.html

Mike

Thx Mike. I've made it work.

Syed