Weird characters in front of the first fieldname when loading data from a text file

[qliknubi]

I am trying to append data to an existing text file test1, but when I load the data, the first column/field has this weird characters   in front of the field name/column name.

It only does that on the first column though. The test1 file is generated  by loading data from qvd files and storing to a text file. When I load it  again using script Load * from test1.txt  (txt, delimiter is '\t'), that's when I get  characters added to the first column title.

Been trying to find answer the entire day but  still not able to figure it out. Thanks in advance

[AshutoshBhumkar]

Hello,

Is that a number formatted column (Year,Id etc).

Try num#() or num().

Could you provide any screenshot or sample data ?

Thanks,

Ashutosh

[rwunderlich · Accepted solution]

Those strange characters are a "Byte-Order Marker" (BOM).  The BOM is included because your load parameters are missing the UTF8 parameter.  Your load should be:

Load * from test1.txt  (txt, utf8, delimiter is '\t')

-Rob

[qliknubi]

@AshutoshBhumkar , yes that fieldname contains number but majority of rows are blank

@rwunderlich , I tried that out since yesterday, but what happens is that, when i put character set argument, it will not load the table. It will only load when character set argument is removed but then again, it has those BOM characters as you mentioned.

The text file that I am loading is from a QVD which was generated from xml files.

This image is after I saved the table again as text2.txt file: 

 Also, when I load and save it again to text2.txt file, I get the message below highlighted in yellow, what does it mean?

 

[marcus_sommer]

If this is a single case or maybe only a few ones you may just rename the field with AS within the load or with ALIAS in beforehand. By a lot of rather not known fields you may use a mapping with a rename-statement (maybe outsourced within a small routine).

Before this I suggest to consider to do the appropriate adjusting already within the xml-load.

- Marcus

[rwunderlich]

When you build the load statement using the wizard, what does the load statement look like?

-Rob

[qliknubi]

Thanks @rwunderlich , my bad. Didn't know that qlik automatically concatenate tables if they have the same exact fields/columns. That was the reason why I can't seem to find the new table when putting in the character set arg. Your solution worked. Thank you.