Dynamic field loading excel files

[vikasmahajan]

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

[maleksafa]

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?

[vikasmahajan]

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

[maleksafa]

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