Robust transform map Issue

[Rafael Batistot]

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

[Robert H]

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

[Rafael Batistot]

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