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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
valkmeister
Contributor
Contributor

tFileList -> tFileDelimited -> tLogRow

Hi,

I'm trying to get the csv files that I need from a directory, but when I run the job the expected result does not appear.

I've tried many configurations and options, but still not working. Eventually, I'm felling that something is missing. So I decided to reproduce the example on the Talend Documentation and other Youtube videos. Tried also on two different operating systems (Windows and Linux) same result.

So right now my test job is this:

It should show the simple data inside the csv, but nothing happening.

On tFileDelimited I'm using: ((String)globalMap.get("tFileList_1_CURRENT_FILEPATH"))

0693p000009HqxMAAS.png

Labels (2)
1 Solution

Accepted Solutions
vikramk
Creator II
Creator II

could you try running the job without "\\" from the filemask and please try to print the context variable in tjava and check whether the path given is correct or not

View solution in original post

10 Replies
Talend_ent
Contributor III
Contributor III

attach tfilelist configuration pic.

 

valkmeister
Contributor
Contributor
Author

0693p000009HrdSAAS.png

vikramk
Creator II
Creator II

could you try running the job without "\\" from the filemask and please try to print the context variable in tjava and check whether the path given is correct or not

Anonymous
Not applicable

Hello,

Please select"Generate Error if no file found" check box in tfilelist component to see if your job will generate an error message if no files or directories are found. If so, you need to check the path of given directory.

Best regards

Sabrina

valkmeister
Contributor
Contributor
Author

Hi Sabrina,

 

Thank you for the kind suggestion. Indeed tFileList wasn't finding the files!

valkmeister
Contributor
Contributor
Author

Hi vikramk,

 

Thank you, it worked! I don't know why, but yesterday I was getting an error when only using "*.csv", and the only way to solve it was by adding the "//". I will now test this on the other job.

 

Regards!

manodwhb
Champion II
Champion II

@Vikram Kumar​ , I do not understand why you are using "\\*.csv" as a file mask, you need to get the csv files in given folder right then use "*.csv" as file mask in tFilelist.

 

Thanks,

Manohar

valkmeister
Contributor
Contributor
Author

Hi Manohar,

 

Because without them I get this error:

0693p000009Hv5jAAC.png

Anonymous
Not applicable

Hello,

Please recheck "Use Glob Expressions as Filemask " option which filters the results using a Global Expression (Glob Expressions).

Best regards

Sabrina