How to load excel data dynamically into QlikView?

[Anonymous]

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

[MK_QSL · Accepted solution]

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?

[Anonymous]

Hi Manish,

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

[Anonymous]

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.

[MK_QSL]

Use FileName() function while loading

[prashantbaste]

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