Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
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.