Normalize company data coming from SCCM integration

[Harika Thota]

Hi ,

Company records for Amazon are created appended with special characters. I found that these company records are coming from SCCM Import sets where they are using robust import set transformer. I cannot create any script to normalize the Amazon records in import set level.

How do I achieve this?

Any lead on this is appreciated.

Thanks in Advance,

Harika

[shubhamseth]

@Harika Thota @You can write the script to transform the value of the field in Integration hub ETL as part of step 2 where you prepare the data. 

you can also go to robust transform map and open detonation and there also you can add the script to transform the values. 

I recommend to this using integration hub ETL step 2.

[Harika Thota]

Hi Shubham,

I don't know how to do it in integration hub ETL.

I didn't see anywhere I can script in Integration hub ETL as well.

Can you please guide me on this ?

Thanks,

[Harika Thota]

Hi Shubham,

I some how  created new transform from the existing u_publisher to u_publisher_1 i had all the conversion script there and it works fine but where do I map this to get u_publisher_1 value instead of u_publisher.

There is no u_publisher in source mapping.

Do i have to create a new attribute

[shubhamseth]

@Harika Thota Great that it worked! You need to map the in step 3. where you will have source and target fields to map. 

Check and let me know if that works.