Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
its_rajvir
Creator
Creator

Loading Multiple XML files at Once

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

 

 

 

 

Labels (4)
1 Solution

Accepted Solutions
Dalton_Ruer
Support
Support

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...

 

 

View solution in original post

1 Reply
Dalton_Ruer
Support
Support

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...