One Star

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.
5 REPLIES
One Star

Re: File delimited using tabulation field separator - problem in tMap

in tFileInputDelimited set the delimiter to "\t"
One Star

Re: File delimited using tabulation field separator - problem in tMap

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

Re: File delimited using tabulation field separator - problem in tMap

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.
One Star

Re: File delimited using tabulation field separator - problem in tMap

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.
One Star

Re: File delimited using tabulation field separator - problem in tMap

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