How to create multiple transform maps from single import set.

[Rajeev Hegde]

Hi,

Can someone tell me how to create multiple transform maps from single import set.

Regards,

Rajeev

[Priyanka136]

Hi Rajeev,

Yes, we can create multiple transform maps from single import set.

1. Multiple transform maps can be applied to single data source.

2. One import set row is created as per transform map. This behaviour can cause a large number of temporary records to be generated.

3. Users can select multiple transform maps during import.

4. The selected transform maps will be executed on the same import set in the order specified.

Let me know if you have any questions.

Please mark it Correct or Helpful, if it works based on impact....!!!!

Warm Regards,

Priyanka

www.dxsherpa.com

[Rajeev Hegde]

Hi Priyanka,

Thank you! 

I have 4 sheets in my excel. I have created new import set table and specifying the sheet number as 1 in  first my import set and creating transform map. Second time I am selecting the same import set table and mentioned sheet no 2 and created the transform map. similar way I have created 4 transform maps. Now the issue is that in all the 4 tables same data is being uploaded even after mentioning order in transform maps.

I am confused where I am doing it wrong.

P.S : In every sheet header row is same. Is it because of that?

Appreciate your help!

Regards,

Rajeev

[Priyanka136]

Hi Rajeev,

Can you please elaborate with attachments ?

Thanks

[Pooja Mallikarj]

Hi  Rajeev,

No ,  every sheet header row is same , we have to change only sheet number.

After creating 4 transforms and running in order also you are getting same data , so i suggest you to check whether particular field is mapped or not if not mapped , map it using mapping assist  manually for every transform map. And you can check mapped fields in data viewer.

And check once the target table , you can set same target table for every transform or else you can change for every transform map.

Thanks and Regards

Pooja Biradar

www.dxsherpa.com