While Load data(fields and Column) using transform map getting extra letters. The excel which I'm loading contains

sruthig
Tera Expert

While Load data(fields and Column) using transform map getting extra letters. The excel which I'm loading contains correct field and choice labels but in ServiceNow import set table and form the label got changed and adding extra wordings. Can anyone please let me know the reason why this mismatch happening.

Please suggest

Regards,

sruthi

6 REPLIES 6

Anil Lande
Kilo Patron

Hi,

Can you please share what additional characters are added ? And what you are trying to upload?

 

Thanks,
Anil Lande

Please appreciate the efforts of community contributors by marking appropriate response as correct answer and helpful, this may help other community users to follow correct solution in future.
Thanks
Anil Lande

Hi Below is the one of the example excel I tried to upload. This is field value of sn_vdr_risk_asmt_vendor_engagement.

But after Done load data-->run transform-->transform the extra letters (問題) added with the label like 第三者.

I can see in the import set table and form like this 第三者問題.

please let me know the reason why this mismatch happening and extra letters added?

find_real_file.png

Ankur Bawiskar
Tera Patron
Tera Patron

@sruthig 

Please provide more information to help us debugging the issue.

Please remember that members that are helping you are not having access to your instance and they can only interpret based on what text you gave. It would be nice if you share some screenshots etc for better debugging instead of looking at text!!

Regards
Ankur

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

Hi Below is the one of the example excel I tried to upload. This is field value of sn_vdr_risk_asmt_vendor_engagement.

But after Done load data-->run transform-->transform the extra letters (問題) added with the label like 第三者.

I can see in the import set table and form like this 第三者問題.

please let me know the reason why this mismatch happening and extra letters added?

find_real_file.png