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