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

Announcements
Only at Qlik Connect! Guest keynote Jesse Cole shares his secrets for daring to be different. Learn More!
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
Champion II
Champion II

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
Champion II
Champion II

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.