How can i update two tables from a transform map

[samadam]

I have an import set where I am trying to do a transform map where it updated few fields on table 1 and few on table 2. IS this possible ? 

[Zach Koch · Accepted solution]

It depends on what tables you are using as your target table. If it has a table that both are extended from you can use this method

Update data in 2 tables through sheet upload, using Transform map. 

Or you could use scripts for the second table 

Can I insert into multiple tables using a single Transform Map? 

[Hajar BENJAHHAR]

Hello @samadam 

You can create two transform maps in this case. The first will update records in table 01, and the second will update records in Table 02. The execution order of these two transform maps should be based on the relationship between the two tables. For example, if you have fields for the User table and fields for the Departments table, and the user being imported is a department manager, the transform map for importing users should run first, followed by the one for departments. The transform map for users should have a  lower order value than the one for departments. 

If there are no dependencies between the two tables, the order of execution of the two transform maps doesn't matter.

I hope you find this helpful!

Best regards, 

Hajar