i Transform map to write to different tables

[CV1]

Hi all,

Looking for help to create a transform map to write data from a single excel to different tables

Table 1:stockroom
Fields : Name,Location

Table2 Hardware Models

Fields:Manufacturer,short descrition,model category

 Table3 Hardware

Fields: Model Category,Model,Quantity,Asset tag,serial no,stockroom,account,state,assignedto

The excel data has following

TIA

Stock Room Name

Location

manufacturer

name

short description

model number

model category

model

asset tag

serial number

account

state

[Neeraj Modi]

Hi @CV1 

This video will help you in achieving the requirement.

Thank you!

Regards,

Neeraj

[SK Chand Basha]

Hi @CV1 1st map the first table data and write the On after script.

If you don't wants to write script split the excel sheet into three and map the data.

Mark it helpful and Accept Solution.If this helps you to understand.

[Community Alums]

Hi @CV1 ,

To achive this functionality you need to create Robust transform map, I worked on this if you want I'll give you step by step solution.

Please mark my answer correct and helpful if this works for you

Thanks and Regards

Sarthak

[Community Alums]

Please refer below steps 

1. Create Data source and under data source we have related list called Robust Transform map

Click new 

2. You need to create Transform defination and than you need to fill all the mandatory fields

3. In ETL defination you can add multiple tables which you want to be fill the data 

Note: here you need to create two more table Staging and Temp table in staging table you need to fill all the data for source table and than you need to map all the staging table data to temp table. Than you need to map the temp table data to Location and Company table  

4. You have to so ETL mappings here you need to select source and target table 

Than you have to perform the mappings in related list.

Feel free to reach me if you have any query.

Please mark my answer correct and helpful if this works for you

Thanks and Regards 

Sarthak