Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

TMap does not work well

I was following the tutorial regarding the translating scenario into a job. I am already in step 2 and I have come across a difference of output being displayed as I am doing a tMap.

 

Looking at the screenshot provided by the tutorial, the columns of the row1 are separated based on the first column entries of the csv file from the metadata (please see attached image tutorial_screen.png). However in my end, the column is being separated by an underscore (please see attached image). I have created a self-made csv file to be used as an input since there was no given csv file for the tutorial itself.  

 

Kindly help me out and hopefully provide me the answer I need.

Thank You!

 

P.S I have also attached images of the preview of the schema as the metadata is being created.

Labels (3)
2 Replies
Anonymous
Not applicable
Author

To read CSV file, you should use tFileInputDelimited component, I guess you don't configure the basic settings correctly on tFileInputDelimited, the first row is header information, so the Header field should be set to 1. As a newbie, I would suggest you to follows the wizards to create a file metadata, and then use it on the component.
https://help.talend.com/reader/I48H6c~0i42r2CnSb9d3tw/czao3RgC5Sjc_m_TaoUaPw

Regards
Shong
Anonymous
Not applicable
Author

I have solved the issue.

 

I just have to change the field separator from semicolon to comma.

 

Thank you for the reply