1 Reply Latest reply: Mar 11, 2017 8:58 AM by Gysbert Wassenaar RSS

    first need to check daily file before multiple file load

    vir vir

      Hi,

       

      I having following script where i need to check daily files present or not .if not than i need to set variable value and need to run other script of the qvw.

       

       

      I have 5 files but not necessary these files should present daily.

      vDate=Date(Today(),'YYMMDD');

      let file1='C:\Users\test\Desktop\files\AF$(vDate).csv';

      let file2='C:\Users\test\Desktop\files\DF$(vDate).csv';

      let file3='C:\Users\test\Desktop\files\SF$(vDate).csv';

      let file4='C:\Users\test\Desktop\files\TF$(vDate).csv';

      let file5='C:\Users\test\Desktop\files\MF$(vDate).csv';

       

      IF(FileSize($(file1))<>0 OR FileSize($(file2))<>0 OR FileSize($(file3))<>0 OR FileSize($(file4))<>0 OR FileSize($(file5))<>0) THEN

      SET vElite='Y';

      ELSE

      SET vElite='N';

      ENDIF

      IF $(vElite)='Y' THEN

       

      LOAD *

      FROM

      [C:\Users\test\Desktop\files\*$(vDate).csv]

      (txt, codepage is 1252, embedded labels, delimiter is ',', msq);

      ENDIF

       

      but this code is not working correctly.

      i want a mechanism that first it should check that file available ...if available than load else set the variable so that we can perform any modfication.