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
Re: How to load excel data dynamically into QlikView?
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.