Hello all,
Here an idea for all Excel+Qlik lovers : I would like to retrieve easily the list of Sheet Names for an Excel File.
Use case : I got dozens and dozens of excel files. Some of them contains a Version sheet, some not. I want to know the version where there is a version sheet and to identify the excel files where it's missing.
I know there is this turnardound https://community.qlik.com/t5/QlikView-Documents/Loading-Multiple-Excel-Sheets-Dynamically-along-wit... but it's really not trivial at all for a user and only work on QlikView.
Alteryx proposes it and it really helped.
Best regards,
Simon
Bi Consultant (Dataviz & Dataprep) @ Business & Decision