ETL and Data Integration tools - Modern ETL software for everyone

Hi

I have to do more imports now for our project and I’m stuck on using my HelpId column.

You know I use the HelpId columns to do a lookup on the records to create the link file (ClientsAddresses) records for example for clients and address. This works great.

Now I have to import Employees and they have also addresses which I have to add to address and then add also link file (EmployeeAddresses) records. This sounds like no problem but unfortunately the Employees have the same HelpId range as the Clients!

Now I think a way to solve this problem is that I could update the address records after the Clients import process and set the HelpId to ‘null’. This could prevent the Employee Import to link wrong addresses to employees.

So I would like to do a simple update on the address table and set HelpId to null. How can I do this with AETL?

Thank you very much for help!

Regards

BG

What you are trying to achieve is simple.

Right click on data writer and select sql editor.

You can run sql before and after data transformation

Mike