How basically transform map will work

Tamil5 · ‎06-12-2017

Hi All,

I have an intermediate table in service now that will be act like a source table when LDAP schedule load runs.

So my source table will be 'imp_location' & the target table is 'cmn_location' (this configuration is done by someone)

When I check the cmn_location table records, everyday update is happening, but 'imp_location' table is empty all the time.

So I though, once the data transform completed these records will be deleted.

Now I need to import my own application data(it has location values) to 'cmn_location'. So I thought of using the same Transform Map.

Created a Datasource Source table. It automatically mapped the Transform Map here.

Created a Scheduled Import with this Data Source & executed.

But data did not move from 'imp_location' to 'cmn_location' table.

'imp_location' did not get cleared & cmn_location table did not get updated with the new values.

Can any one help me with this?

Thanks

Prici

Tamil5 · ‎07-04-2017

Hi Trena Fritsche,

Thanks for your time & really sorry for the delayed response.

Actually the solution was pretty simple.

I think I got confused a lot (since this the first time i'm working with Transform map).

My big mistake was, I tried to use the existing staging table which is populated by webservice. I thought, populating my data in that table will automatically moved to cmn_location.

And tried hard to make it work.

Then I tried to create a new staging table & mapped columns with cmn_location using transform map.

And executed my API code. It populated the data perfectly in my staging table & then automatically transferred to cmn_location.

My another issue,

I had some cleanup script in post transform script for staging table, so I was not sure whether it is transferring data properly.

Simply creating transform map the new staging table did the magic.

Thanks

Prici

View solution in original post

jyoti29208 · ‎06-12-2017

Hi Prici,

Got an article for you that might helpful Creating New Transform Maps - ServiceNow Wiki .

Please provide your feedback appropriately (Like, Helpful, Endorse AND/OR Correct) to help community.

Thank you!

Regards,

Jyoti

Ashish Nahar · ‎06-12-2017

Go to the Data Source and validate if the transform map is still attached to the imp_location.

Tamil5 · ‎06-12-2017

Hi ,

Yes I have checked it & the transform map is still mapped.

Please check the screen shot below, whether the fields which I highlighted in yellow causing issue ?

Ashish Nahar · ‎06-12-2017

it would be good to have a new transform map created for the new import you want to perform. until we see the process, it would be not easy to tell why the data is not populated. As you are using an existing transform map for your new import the fields are not mapped or many other.

I would recommend leaving alone the working one as it is and creates a new transform map (as highlighted by Jyoti) for your upload you are performing.

http://wiki.servicenow.com/index.php?title=Creating_New_Transform_Maps#gsc.tab=0