topic Re: Dynamic field loading excel files in QlikView

Dynamic field loading excel files

vikasmahajan — Fri, 23 Oct 2015 05:09:30 GMT

Dear all ,

I have excel file I want to load this Dynamic fields loading in Qlikview please provide me a script which load will

load all 3 excel sheets in attached excel and give field names like field1,field2,filed3 .... and will have all data of

3 tabs in attached sheet.

I want this urgent does anybody have script with suitable example ?

Thanks

Vikas

Re: Re: Consolidate multiple fields into one

Re: I am trying to load an excel file that has more than one sheet with different field names but has the same type of data.

Re: Dynamic field loading excel files

maleksafa — Fri, 23 Oct 2015 06:41:03 GMT

m not sure why you need this dynamic load thing? are the column number and labels fixed? number of tabs as well?, why can't you read the same excel 3 times, each time reading one sheet?

Re: Dynamic field loading excel files

vikasmahajan — Fri, 23 Oct 2015 07:05:19 GMT

Thanks for reply , labels are not fixed in each sheet thats why I want to get F1,F2,F3,... as field name and I have 30 excels to load in QV. So in future it will be 50 or more ...

Thats why i want dynamic load with field name as dynamic.

Thanks

Vikas

Re: Dynamic field loading excel files

maleksafa — Fri, 23 Oct 2015 08:15:16 GMT

but even if you managed to import it dynamically how will you plan to use them in your charts as expression or dimensions if they will keep on changing?

for loading dynamic excel sheets you can check this link Loading Multiple Excel Sheets Dynamically along with file name and sheet name