topic Re: logic Help. in QlikView

logic Help.

lalitkgehlot89 — Wed, 25 Nov 2020 16:16:04 GMT

Hi Every One.

I want to skip 9 and 13 no row in Excel during load how do we need to do.

Thanks,

Lalit Kumar

Re: logic Help.

avinashelite — Tue, 10 May 2016 06:12:06 GMT

you could assign a rowno() column and do a resident load ...

Try like this

TEST:

LOAD *,

rowno() as Number

from excel;

Result:

LOAD *

resident

TEST

where Number<>'9' and Number<>'13';

drop table TEST;

drop field Number;

Re: logic Help.

phaneendra_kunc — Tue, 10 May 2016 06:13:31 GMT

add this where clause..

where not wildmatch(RecNo() , 9,13);

Re: logic Help.

lalitkgehlot89 — Tue, 10 May 2016 06:26:19 GMT

Thanks a lot Phaneendra,

Its working.

Re: logic Help.

PrashantSangle — Tue, 10 May 2016 06:41:36 GMT

Hi,

or you can remove it while loading like

add below filter function at end of file property

filters(

Remove(Row, Pos(Top, 9)),

Remove(Row, Pos(Top, 13))

)

your script like

Load *

from Filename

(ooxml, embedded labels, table is Sheet2,

filters(

Remove(Row, Pos(Top, 9)),

Remove(Row, Pos(Top, 13))

)

or try with Enable Transformation steps

Kind Regards

Re: logic Help.

Mahamed_Qlik — Tue, 10 May 2016 06:43:10 GMT

Hi Lalit,

Better you can try to use the variable rather putting the hard coded value.

Regards,

Mahamed