topic Re: How to load excel data dynamically in QlikView

How to load excel data dynamically

Anonymous — Thu, 24 Sep 2015 03:42:26 GMT

Hi all,

I have loaded excel file (excel1) already into qlikview with the field names of (Country,State,productname,soldyear......like 60 columns)--->this data for July month 2015.

I am trying to load related data to above but with column header name are slight different.But i need to concatenate to above excel1.

I know that rename in script will be work but it takes long to change because i have 60 columns.

Could you please help me on that how can add data to excel1 without changing header columns?

Thanks,

Rajesh

Re: How to load excel data dynamically

qlikviewwizard — Thu, 24 Sep 2015 05:11:23 GMT

Hi,

Please check the following threads if help.

Load Multiple excel sheets using For loop

Load all Excel files and all sheets in a folder

Load latest Excel file to Qlikview

Re: How to load excel data dynamically

Ralf-Narfeldt — Thu, 24 Sep 2015 05:21:27 GMT

Hard to get around with some renaming, but it can be minimized if you have many files with same structure (same amount of fields in same order).

Say you have the first load:

LOAD

Field1,

Field2,

Field3

FROM [file1] (ooxml, embedded labels, table is Sheet1) ;

For the next loads you can change to refer to generic column headings and rename, by setting to no labels and header is 1 lines (to ignore the labels):

LOAD

A As Field1,

B As Field2,

C As Field3

FROM [file2] (ooxml, no labels, header is 1 lines, table is Sheet1)

As you see, some renaming needed, but it follows a pattern and can be used in the methods of looping through many files like in the threads that qlikviewwizard linked to. Again, it does require that all files have the "same" columns (but with different names) and in same order. If that's not the case, it gets more complicated.