Data360 Analyze

 View Only
  • 1.  how to read chinese characters use excel node?

    Employee
    Posted 06-04-2020 01:19

    there are some error when I read the excel contains chinese characters use Excel Node,  can set UTF-8 when read excel? or other suggestions? thanks



  • 2.  RE: how to read chinese characters use excel node?

    Employee
    Posted 06-04-2020 03:39

    In Analyze Field metadata cannot contain (multi-byte) Unicode characters. Do the column headers in the Excel worksheet contain Chinese characters?  e.g.

     

    You can import unicode data provided the metadata (column headers) are single-byte unicode or string type. e.g.

     



  • 3.  RE: how to read chinese characters use excel node?

    Employee
    Posted 06-04-2020 19:51

    thanks very much, it works, just the header contains Chinese characters, when I change to single-byte, it works, thanks for your suggestions.