String field changing the characters while doing a transformation

[trinadh2]

Hi,

We have a String field in our staging and target table which has to copy the value from the sheet. when we are loading the data(transform map) it is changing the value which is being sent Example: if the value is like this 박명선 it is converting it something like l朱æ•�. When tried to updated the field manually it is getting copied correctly. Not sure what is causing the issue. We have the Chinese Translation in our instance   

@Ankur Bawiskar  could you please help me on this.

Thank you.

[Ankur Bawiskar]

Hi,

I hope you are logging in as chinese user to confirm the value when you are checking on target table

Regards
Ankur

[trinadh2]

@Ankur Bawiskar  Nope i am logging in normally and seeing that the values are different, the other thing which we noticed is when we are uploading the XLSX file. When we upload the csv then only we are seeing the issue.

Thank you

[Ankur Bawiskar]

Hi,

Please login with chinese user and verify the exact value.

Also check the file encoding when you are using Excel or CSV

Regards
Ankur

[trinadh2 · Accepted solution]

The file that im loading is having the issue, the source file provided has made some changes while sending the file and the issue is fixed now. thank you:)

[DP10]

What change did you have to make to file? Having same issue