Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I need to loop on all the sheets of all Excel files in a given folder.
I used the jet provider solution found on the forum in Qlikview :
But it doesn't work with QlikSense. Do you know how to handle that ?
Thanks
Actually I should have digged a little bit before asking, it's simple :
ODBC CONNECT To [Excel Files;DBQ=$(File)];
Then load the SQLTables:
tables:
SQLtables;
then loop in this table.