topic Re: Requirement on Removing Row from Excel Sheet in QlikView

Requirement on Removing Row from Excel Sheet

Wed, 25 Nov 2020 16:16:04 GMT

How to Remove Row from Excel Sheet while loading into the Script .

alexdataiq — Mon, 06 Jun 2016 18:06:49 GMT

Could you provide an example? Are you trying to remove headers or rows given a certain condition?

Clever_Anjos — Mon, 06 Jun 2016 18:06:59 GMT

LOAD *

FROM yourexcelfile

WHERE <clause>;

<clause> can be a rule, for example isnum(A);

santiago_respane — Mon, 06 Jun 2016 18:12:58 GMT

Hi,

it would be easier to help if you could share a sample app, but maybe this helps you.

To omit some rows based on data you use Clever tip but to omit specific rows based on the excel file format you can do this:

MyLoadedExcel:

LOAD *

FROM

[My Excel.xlsx]

(ooxml, embedded labels, table is [MyDataSheet],

filters(

Remove(Row, Pos(Top, 1)), //this rule removes the first row

Remove(Row, RowCnd(CellValue, 1, StrCnd(start, 'Total'))) //This rule removes all rows that starts with total

Remove(Row, RowCnd(CellValue, 1, StrCnd(equal, 'Report Title'))) //This rule removes a row which value is 'Report Title'

)

);

You could take a look at excel loading filters in the wizard.

Please let me know if this helps.

Kind regards,