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

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

File delimited using tabulation field separator - problem in tMap

Hello,
I have a tMap which map a .txt delimited file and a metadata table.
In the tMap, all the fields in the delimited file is displayed as a single line. Please see the image of the tMap.
I tried to check "trim all column" in the file advanced settings, but it still doesn't give me each field in separate line.
I have no problem with the csv file, but the .txt file
Thank you very much for your help.
Labels (2)
5 Replies
janhess
Creator II
Creator II

in tFileInputDelimited set the delimiter to "\t"
Anonymous
Not applicable
Author

Hi there,
I did set the delimiter to "\t" as in the attached image, and I don't get it works.
Thanks.
Anonymous
Not applicable
Author

Hi
First of all your txt file, does it have , or ; when seperating the fields together. What do you get when you click the preview button.
Could you show me a clip of it and i insist you. I also had a problem with the txt files but managed to sort it out though.
Anonymous
Not applicable
Author

Hello,
The .txt file doesn't have , or ; It is tab.
Please see the image for the file format when I click on the preview.
Thanks very much for your help.
janhess
Creator II
Creator II

What does the data look like?
There's no output in your tMap
There's no join between the 2 inputs. Is that correct.