Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Multiple validation on count of files

Hi Team,

 

We need perform below validation before start our process.

1. Directory should have exact 5 files and it should be CSV.

2. File prefix should be fixed for each file like "MRA_TOP_MFP".

3. Match the each filename in a table which were already processed.

 

I was able to achieve some design for point 1 but I can't able to match for exact 5 files.

This works "((Integer)globalMap.get("tFileList_1_NB_FILE"))>4" for only greater than or less than comparison.. I couldn't able to do for '=' or '<>'. Please suggest.

 

I am attaching the design which I did.

0683p000009M6wg.jpgCount check

Labels (2)
3 Replies
TRF
Creator III
Creator III

Replace = by == and <> by !=
Anonymous
Not applicable
Author

Thanks this works.

However, could you please suggest how I can print some user friendly message after this check like " file count doesn't match". Is there any component which print in console as I am using tRedirect component which later on take that console details to a file.

TRF
Creator III
Creator III

Use a tWarn + tLogCatcher or a tJava with the desired System.out.println().
Thank's to mark your case as solved as your initial question has been answered.