topic Re: How to load excel data dynamically into QlikView? in QlikView

How to load excel data dynamically into QlikView?

Anonymous — Wed, 15 Jul 2015 09:14:59 GMT

Hi There,

I have a requirement where in I have to convert the received excel data into custom format and then use it in qlikview. This I had to do every year. For this purpose I want to create a qvw file which fulfills the process automatically by taking the excel data every year. Can anyone please help me. For example, the data received is as follows

Date Working Day Date Working Day

1/1/2013 0 1/1/2014 0

2/1/2013 1 2/1/2014 0

3/1/2013 1 3/1/2014 1

31/12/2013 0 31/12/2014 0

Custom Format to which it has to be converted automatically

Date Working Day

1/1/2013 0

2/1/2013 1

3/1/2013 1

31/12/2013 0

1/1/2014 0

2/1/2014 0

3/1/2014 1

31/12/2014 0

Re: How to load excel data dynamically into QlikView?

MK_QSL — Wed, 15 Jul 2015 09:17:21 GMT

You can load excel files and concatenate them. What is the issue?

Load * From ExcelFile where Year(Date) = 2013;

Load * From ExcelFile where Year(Date) = 2014;

Load * From ExcelFile where Year(Date) = 2015;

etc.. Is this what you are looking for?

Re: How to load excel data dynamically into QlikView?

Anonymous — Wed, 15 Jul 2015 09:28:12 GMT

Hi Manish,

Thank you very much that was helpful. This was a part of what I was doing .

Re: How to load excel data dynamically into QlikView?

Anonymous — Wed, 15 Jul 2015 10:24:47 GMT

Hi Manish,

Is it possible to take the excel file names as field value dynamically like for example,

I have loaded the data from excel file named "Dell" and wanted to assign it as value under the field name "Company" which was not there in excel file and would like to associate it to the dates loaded from that file,and want to do it dynamically. Pardon me if the question was a bit confusing.

Re: How to load excel data dynamically into QlikView?

MK_QSL — Wed, 15 Jul 2015 10:31:44 GMT

Use FileName() function while loading

Re: How to load excel data dynamically into QlikView?

prashantbaste — Wed, 15 Jul 2015 10:33:27 GMT

You can use filename as a value in field -

Load *,

filename( ) as Filename from

Dell.xls (ooxml, embedded labels, ...);

Hope this will be helpful for you.

Regards,

Prashant P Baste