Hello Developers,
I have one requirement to build š
I need to import some data into the target table.
I have Location table in ServiceNow with different hierarchy levels ( building , state, country, region etc.)
I have one field on location table called "Department" ( this is available only on country form where hierarchy level=country) on other records in location table where we have different hierarchy levels this field is not present.
I want to import the data into this Department field where hierarchy is country based on country code.
In my excel I have two columns created ( which have Country code , Department).
I have created import set table with desired fields and also data source.
Please help me out with transform map..
Country code field is also available on country form where hierarchy level is country
I need to import the data into the target table into that department field which is only available on the country form.
(where hierarchy is country)
Please help me with the logic , how should I check the target table records where hierarchy level == country
and then I will do one to one mapping of country code and department.. while transforming..
Thanks !
