Qlikview Notes

IF Alt(FileSize(vQVDPath & ‘\’& ‘TBL_EMP.qvd’), 0) = 0 THEN TBL_EMP: LOAD *, Date(Floor(Date#(DATE, ‘DD/MM/YYYY hh:mm’))) AS DATE_FORMAT, FileName() AS Source_FileName FROM [$(vFilePath)\*TBL_EMP.csv] (txt, codepage is 1252, embedded labels, delimiter is ‘,’, msq); Concatenate(TBL_EMP) LOAD *, Date(Floor(Date#(DATE, ‘YYYY-MM-DD hh:mm:ss TT’))) AS DATE_FORMAT, //2015-12-21 09:00:00 AM FileName() AS Source_FileName FROM [$(vFilePath)\*TBL_EMP.dat] (txt, codepage is 1252, embedded labels, delimiter is ‘|’, msq, header is 1 lines); ELSE TBL_EMP: … Continue reading Qlikview Notes