topic Re: Multiple validation on count of files in Talend Studio

Multiple validation on count of files

Anonymous — Sat, 16 Nov 2024 04:44:04 GMT

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.

Count check

Re: Multiple validation on count of files

TRF — Mon, 09 Sep 2019 14:34:43 GMT

Replace = by == and <> by !=

Re: Multiple validation on count of files

Anonymous — Tue, 10 Sep 2019 13:58:19 GMT

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.

Re: Multiple validation on count of files

TRF — Wed, 11 Sep 2019 10:59:32 GMT

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.