Load issue for .xlsb files in a directory

[Anonymous]

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 ?