Helllo,
I want to put on a table the name of all files .xlsb existing in a local directory. There are 4 files in my directory.
On the script i wrote (DirSource is the entire name of the local directory) :
TMP_FILES :
LOAD distinct
FilePath() as D_TMP_FILES_NOM_COMPLET,
filebasename() as D_TMP_FILES_NOM,
FileTime() as D_TMP_FILES_DATEMODIF,
date(Date#(Mid(filebasename( ),16), 'DD MMM YYYY')) as D_TMP_FILES_DATARRET
FROM '$(DirSource)\*.xlsb';
But i not understand the result of the script execution : 4 files are "detected" , but only 3 are added on the table TMP_FILES
TMP_FILES << 05 - BAG BS au 09 Mai 2018 11 Lines fetched
TMP_FILES << 06 - BAG BS au 14 Juin 2018 12 Lines fetched
TMP_FILES << 06 - BAG BS au 28 Juin 2018 13 Lines fetched
TMP_FILES << 09 - BAG BS au 18 Sept 2018 3 Lines fetched
3 rows in TMP_FILES
The last one "09 - BAG BS au 18 Sept 2018" is not added.
I don't understand why. Can someone help me to solve my problem ?