transform map

[Gaurav69]

Hii, I want to update the emails of some users in my user table using transform map. I have created a xml file with the user ID and New emails. loaded this data and also created a transform map. but its not working. 

[Tony Chatfield1]

Hi, unfortunately your post contains no clear details of what did\didn't work, or your code\configuration.
Normally data would be loaded into temp import table via csv file, not xml.
Can you share details of your configuration\field mapping and transform script(s) (if any)

[Jitendra Diwak1]

Hi @Gaurav69,

This can be done by creating an excel file and store the data according to your requirement and keep the ID as coalesce and map the field according to staging table and run the map. 

Please accept the solution if it works

Thanks

Jitendra