ETL and Data Integration tools - Modern ETL software for everyone

Hi,
This is Syed. Working as Technical Architect in Payroll Systems.

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.

Hello

Use lookup object

Use this sql as source for the lookup
SELECT EMPLOYEE_ID,SYSTEMNO FROM EMPLOYEE

Also watch our on-line tutorials
www.dbsoftlab.com/etl-tools/advanced-etl...online-tutorial.html

Mike

Found a tutorial for you
www.dbsoftlab.com/online-tutorials/advan...g-lookup-object.html

Mike