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