Exclude an excel row

[#1]

Hello All,

     I am in a project. Source is the excel sheet.

     In that, usually the first row is the header and the 2nd row contains the description abt the first row i.e., header row.

     My pblm is that I want to load that sheet into qlikview excluding the description.

     Do anybody have solution for this..?

     Thanks in advance.

[gussfish · Accepted solution]

Hi Rajan,

if you're using the "Table Files..." wizard to construct the LOAD statement for your Excel, then

1. when you get to the stage with the "Enable Transformation Step", press that button.  It will then give you a grid view of your data on its 'Garbage' tab. 
2. Select the row you want to ignore by clicking on its number and the press 'Delete Marked'. 
3. From there, finish the wizard by clicking Next and/or Finish.

You will then observe that the resulting LOAD statement includes a filter for removing that row every time.

Regards,

Angus.

[#3]

Hello Gussfish,

     Thank u for ur response. I got the result.Thank u once again.