Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Everyone,
I am new to Qlik Sense.
I am trying to load multiple XML files (More than 200) at once from a folder, each file having different fields and Size but unable to do so. Can't load each and every single file, it would be time consuming. Is there any easy way to do so? Any script using which i can load these files at once looping etc. ?
Could someone answer this for me please. It would be very helpful.
Best Regards
Rajvir Kaur
Why are you trying to load 200 XLS files that all have different field names? I'm guessing that blindly loading them all will create a crazy data model.
However, checkout the solution in this post: https://community.qlik.com/t5/Connectivity-Data-Prep/Qlik-Sense-Load-all-files-from-a-folder/td-p/13...
It will show you how to use a filelist in Qlik Sense. Then lookup other file functions like FileName so that you can use them for the TableName since you will want 200 different table names: https://help.qlik.com/en-US/sense/February2021/Subsystems/Hub/Content/Sense_Hub/Scripting/FileFuncti...
Why are you trying to load 200 XLS files that all have different field names? I'm guessing that blindly loading them all will create a crazy data model.
However, checkout the solution in this post: https://community.qlik.com/t5/Connectivity-Data-Prep/Qlik-Sense-Load-all-files-from-a-folder/td-p/13...
It will show you how to use a filelist in Qlik Sense. Then lookup other file functions like FileName so that you can use them for the TableName since you will want 200 different table names: https://help.qlik.com/en-US/sense/February2021/Subsystems/Hub/Content/Sense_Hub/Scripting/FileFuncti...