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

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

[resolved] Problem load data into tFileOutputDelimited

Hi,

I'm load data from mssql to tFileOutputDelimited. After checking data in .txt. The output as below :


0683p000009MFvS.png

Certain data on COLUMN5 down to bottom line. How to solve this problem? why it is happen?

Labels (2)
1 Solution

Accepted Solutions
vapukov
Master II
Master II

it normally work fine, as You can see from picture - some of rows correct, other look like additional row separator inserted
You can test - manually clean COLUMN4 and COLUMN5 in tMap, rowXX.COLUMN4.replaceAll("[^a-zA-Z ]") and rowXX.COLUMN5.replaceAll("[^0-9]") (You can change regex) - it just to be sure - no hidden symbols in data 

View solution in original post

3 Replies
Anonymous
Not applicable
Author

Hi,
We cannot repro this issue on V 6.2.1.
How did you set "Row Separator" on tfileoutputdelimited component?
Best regards
Sabrina
Anonymous
Not applicable
Author

Row separator : "\r"+"\n"
Any suggestion.
Thanks.
vapukov
Master II
Master II

it normally work fine, as You can see from picture - some of rows correct, other look like additional row separator inserted
You can test - manually clean COLUMN4 and COLUMN5 in tMap, rowXX.COLUMN4.replaceAll("[^a-zA-Z ]") and rowXX.COLUMN5.replaceAll("[^0-9]") (You can change regex) - it just to be sure - no hidden symbols in data