Automation of Transform Map - Sheets in the excel should automatically be transformed.

[Maruthi Ram]

I have an excel sheet with 8 tabs in it. Each tab has its own transform map. When we upload the excel in datasource and choose to run the transform for sheet1 , using the transform map data is uploaded into the target table.

Now the Ask is : Sheet2 should be transformed automatically into target table only upon successful completion of sheet1. Likewise sheet3 should start automatically when sheet2 is transformed successfully and so on.

How Can i achieve this?

[bubuprasadswain]

Hi @Maruthi Ram ,

You can create a Scheduled Import and add multiple transform maps to import data. You have to define Transform Map Order (100,200,300...) to execute one after another. 

Hope this helps and satisfy what you are looking for.

Regards,

Bubuprasad 

[Maruthi Ram]

@bubu2 : Thanks for the response , but where do we give the condition to wait for sheet2 until sheet1 is completely finished?? Also i have another condition to satisfy

condition : Wait for sheet1 to upload completely and key!== " "(Key value not null) ONLY then start with sheet2.

Any lead on how to achieve this?