Excel Data load in Qlikview

[Anonymous]

Hi all,

I have a task of loading the data from excel file in qlikview . ill tell you the complexity in it.

Consider i have two excel files, and each excel file is having 3 sections of data in it as follows (please verify with the attached sample excel sheet , here you can find Company Branch A,B,C as a keyword before table is started. so this might be a key to load)

Company Branch A

Company Branch B

Company Branch C

And here, i always want to load only the data of Company Branch B section,

Consider as an example in first file, Company Branch B section start from row 10 - 14 in excel sheet, so it should load only those 5 rows.

Consider as an example in second file, Company Branch B section start from row 50 - 150 in excel sheet, so it should load only those 100 rows.

Please let me know how can i do this.?

Thanks..

[effinty2112]

Hi Kishore,

                        In the File Wizard go through the Transformation Steps.

The steps I took were

1. Add a new column. copied column 1 where it started with Company Branch

2. Fill column 4 with cell condition empty from above.

3. Delete rows where column 2 is empty.

4. Delete rows where

condtion 1 : column 3 = DOJ

then add condition 2:

Start from row 2 from top, to row 1 from bottom (second row to last row), Select 1, Skip 0

Rename your columns in the wizard on into the script when finished.

The only way to learn to transform these flat files is to work with the wizard. It may be tricky at first but you will figure it out.

cheers

Andrew