Hi Team,
Let me know if you can help me.
I've trying a simple robust transform map process. See the what i did step by step
This my excel file. As you see it's a process to create category and subcategory.
i've been upload this file and Load Data and create a Data Source and a Robust Transform Map
In this ETL Definition i have 3 ETL Entities and 2 RTE Entity Mapping
In importSet, Staging and Choice are the same value
Here my RTE Entity Mappings. Import to Staging and Staging to choice
When i back to Data Source to Load all record
When i run the Robust transform map
After that, this the issue that i got and this records are not created
Kindly help me
Thank's in advanced
Hello @Rafael Batistot ,
First of all, may I ask why you have chosen to implement this using a Robust Transformer?
Your import has only a single target table (Choice [sys_choice]) and your Excel file exactly matches the structure and field names of that table.
Therefore this would be much easier to implement using a single (regular) Transform Map. All you need to do is to create the Transform Map, click Auto Map Matching Fields, and adjust the Coalesce configuration as shown below.
A Robust Transformer is best suited if you have multiple target tables, but it's much more complicated to build and debug.
Regards,
Robert
Hi @Robert H, thank you to answer me.
That's true, but this is the first part. Once i got this transform map working i need to figure out how can i send a excel file with 2 sheets because the second part is insert the same datas in the table "dl_u_assignment_list"
First of all i need to learned how it`s work. After that i can adjusts in my personal process
