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

Announcements
Qlik Connect 2026 Agenda Now Available: Explore Sessions
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

FileOutputDelimited writes to a wrong file

Hi,

I once more need help with a Talend Job Im writing. The Task of it is to check if certain Files are in a directory, rename those and to write a log.txt if there are any problems. The log is written by a tFileOutputDelimited with informations given by a tJavaRow-Code. After testing the Job Ive run into a big and for me strange Problem. Lets say there are 3 Statements to be written in the log (a, b and c). The log in the end contains only b and c, while a is missing. Its always the first one that is not there, the other are normally written to the log in the exact directory. By Accident Ive found the missing Statements on my desktop in a File called "testnull.dat" where the Job has written all the missing statments from the last 2 days I tested this Job.

I really have no clue how to solve this or where it could come from. I hope I could explain my problem properly. If there are any additional informations needed, I will try to provide them.

Labels (1)
1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

Do you mean the output is wrong or the component fills a wrong file (e.g. the wrong path + file name)?

What you cannot do is to use a value from the flow and use it as output file name.

The output file will be created tight at the start of the process just at the first iteration between tFileList and the 2 component.

View solution in original post

15 Replies
Anonymous
Not applicable
Author

Hi Bamsen..

 

Before writing into delimited file just check with tLogRow .

Anonymous
Not applicable
Author

I already have a TlogRow before the output and i can see nothing suspicious.

Anonymous
Not applicable
Author

Send your screen shots I will look once
Anonymous
Not applicable
Author

0683p000009Lrjf.pngSo this is how my Job looks like0683p000009LrnL.pngAnd this is the tLogRow, logfile is the name of the log (Timestamp), output is the String written to the log and fall is just the case, just something for testing

Anonymous
Not applicable
Author

Use another one logrow after the delimitedfile .If it's give same log output ..The problem may be in schema of our delimited file.

Anonymous
Not applicable
Author

Ive tried your suggestion, the new tLogRow prints the same as the one in front of the FileOutputDelimited. 

Anonymous
Not applicable
Author

check your schema of logrow and delimitedfile..

 

if you pass three values you must have three fields in schema.0683p000009Lrm4.png

Anonymous
Not applicable
Author

0683p000009Lqo1.png

all the fields are in every schema 😕

Anonymous
Not applicable
Author

Check your column value contain any delimited character?

Your input values to delimited file must not contain specified delimited character.