Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Below Code is just reading 15 lines.. where as folder has 25 files.. If I remove distinct it loads duplicate file names.. what am I doing wrong?
vRoot = directory path
File_name:
LOAD distinct
FileName() as "Data_File"
FROM $(vRoot)\*.xlsx;