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
