I have a set of Excel-files, all with the same column headers but with a vairable amount of rows which contain data. Below the rows with the data I want to retreive, some other calculations are performed.
An example is given in the uploaded file:
- In this file two sets of data (in reality representing two files) are in sheets "SourceFile1" and "SourceFile2".
- Only the data in yellow are to be imported.
- The headers of the columns (in blue) are used as header in Qlikview as well and are identical for all source-files.
- The data in red (in the same columns as the yellow cells) need to be ignored on importation.
- The basic result in Qlikview is shown in sheet "Output in Qlikview".
If I load the whole sheet, I become rubbish in the tables because I only need the base data (product names and amounts = yellow cells) but all data (also the calculations) are imported and shown in my table.
Extra information on the source-files: The structures is always the same.
- Row1: Column header
- Row2: White line
- Row3...X: Products
- Row X+1: White line
- Row X+3: Start other calculations (to be ignored in script).
The only variable is here "X" (=amount of products), but is unknown at time of executing the script.
Can someone help me to create a LOAD-statement that can perform the above ?
Thanks in advance !
Message was edited by: brugst13 upon request from Deepak Vadithala
.png "Luminary Alumni"){kind=icon}