# Join multivalue fields

**URL:** <https://forum.cloverdx.com/t/join-multivalue-fields/1778>\
**Category:** CloverDX Platform\
**Created:** [August 17, 2016, 12:00am UTC](https://forum.cloverdx.com/t/join-multivalue-fields/1778 "2016-08-17T00:00:00Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![raycheng1688](https://avatars.discourse-cdn.com/v4/letter/r/71e660/32.png) [@raycheng1688](https://forum.cloverdx.com/u/raycheng1688)\
**Post date:** [August 17, 2016, 12:00am UTC](https://forum.cloverdx.com/t/join-multivalue-fields/1778/1 "2016-08-17T00:00:00Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![PedroVazquezRosario](https://avatars.discourse-cdn.com/v4/letter/p/ed8c4c/32.png) [@PedroVazquezRosario](https://forum.cloverdx.com/u/PedroVazquezRosario)\
**Post date:** [August 18, 2016, 6:17pm UTC](https://forum.cloverdx.com/t/join-multivalue-fields/1778/2 "2016-08-18T18:17:22Z")

</div>

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](http://doc.cloveretl.com/documentation/UserGuide/index.jsp?topic=/com.cloveretl.gui.docs/docs/xmlextract.html). 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)
