Join multivalue fields

I have a xml file which contains Chinese Name, we have a Field chinese_name( like this format 孟秋秋), we want to join each chinese character into unicode from other files.

How can I reading this field(chinese_name), i know it is multivalue field, but i don’t know how to do actually!

Can anyone help! I’m new to ETL.

Thanks in advance

Hi,

Could you please elaborate more on joining each Chinese character into Unicode from other files? If you want to extract data from an XML file, I would recommend using our XMLExtract component, read more here. In the properties of the XMLExtract you can change the Charset to match the encoding that reads Chinese characters (ex. UTF-8 or Big 5)