How to identify error files and moving to seperate folder ?

madhubabum — Fri, 11 Dec 2015 12:43:13 GMT

Hi Experts

I am Having Multiple file files in a single folder:

SampleFiles:

EmpData,EmpData1,EmpData2,.......EmpData10.

Note : Some files are Having Header information,

Some files Not having Header Information,

Some fields are Missing,

Some files are not Having Data

Step1 : How We can identify which file is having Errors

Step2 : Then move the error files into separate folder .

Step3 : Move files , which are not having error files into another folder.

Please help to me write the script to identify the error files.

Please find attached files for testing.

Thanks in advance

Regards,

Madhu

Re: How to identify error files and moving to seperate folder ?

marcus_sommer — Fri, 11 Dec 2015 14:52:16 GMT

You need to run through this folder with filelist, check your conditions (probably per if-loops) and move them per execute-statement. Here some examples:

Re: Pick the latest excel file from folders

Re: how to skip a Excel Workbook ?

EXECUTE command to MOVE shared files but DON'T Overwrite

- Marcus

topic How to identify error files and moving to seperate folder ? in QlikView

How to identify error files and moving to seperate folder ?

Re: How to identify error files and moving to seperate folder ?