logic Help.

[lalitkgehlot89]

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

[avinashelite]

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;

[phaneendra_kunc]

add this where clause..

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

[lalitkgehlot89]

Thanks a lot Phaneendra,

Its working.

[PrashantSangle]

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

[Mahamed_Qlik]

Hi Lalit,

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

Regards,

Mahamed