Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

udaykiran
Contributor

How to load excel data dynamically into QlikView?

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

1 Solution

Accepted Solutions
Highlighted

Re: How to load excel data dynamically into QlikView?

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?

5 Replies
Highlighted

Re: How to load excel data dynamically into QlikView?

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?

udaykiran
Contributor

Re: How to load excel data dynamically into QlikView?

Hi Manish,

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

udaykiran
Contributor

Re: How to load excel data dynamically into QlikView?

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?

Use FileName() function while loading

prashantbaste
Contributor II

Re: How to load excel data dynamically into QlikView?

Hi

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

Community Browser