topic Exclude an excel row in QlikView

Exclude an excel row

Fri, 20 May 2011 05:39:02 GMT

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 — Fri, 20 May 2011 05:45:38 GMT

Hi Rajan,

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

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.
Select the row you want to ignore by clicking on its number and the press 'Delete Marked'.
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.

Fri, 20 May 2011 05:51:48 GMT

Hello Gussfish,

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