Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
qlikviewforum
Contributor II

Replace and store it in excel

Hi,

Can someone help me on this?

Imagine if I am loading the data from multiple excelsheet which is in format ExcelName_YYYYMM then I am doing required aggregation and joins to get the data in required format.Imagine if I have all the required data in the "Table1".

Table1:
Load Path,
     Category,
     FileType,
     FileName,
     Subcategory
Resident Temp;

In the above table field contains the flag called "PICK" or "LEAVE". So whatever the rows contains the flag called "LEAVE" then I want to replace the path and save it in the same excel.Imagine if the above table contains 60 records which we need to leave. If the first excel contains 25 records each with flag as "LEAVE" then I need to replace the path and save the excel(i,e ExcelName_201301,ExcelName_201302 and only 10 records in EXcelName_201303 which is flagged as "LEAVE" rest as "PICK"). We need replace the path and save it as an excelfile with the same name where it was read and and also replace it in the same location.

May I know how this can be achieved?

Regards,

qvforum

Tags (3)