Remove multiple columns with filter while Load data - Syntax

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

Hi!

I'm trying to Load cross table

with a script by

from this thread

S1:
CrossTable(atr, Data, 2)
LOAD * FROM
crosstable.xlsx
(ooxml, no labels, table is Sheet1, filters(
Remove(Row, RowCnd(Interval, Pos(Top, 2), Pos(Bottom, 1), Select(1, 0)))
));
store S1 into S1.txt(txt);
drop Table S1;

here we remove Rows, but I need to remove Columns also

I can remove one Column: Remove(Col, Pos(Top, 5))

what syntax is for Removing Multiple Columns

but what syntax is for Removing multiple columns ?

Re: Remove multiple columns with filter while Load data - Syntax

Anonymous — Wed, 14 Feb 2018 13:05:48 GMT

I solved it by ignoring columns in the LOAD statement:

i.e. ignoring [Pack Size] and 2nd [Description]

//Header in the file:
//Account Name,Customer Address 1,Post Code,Document Date,Description,Pack Size,Description,Line Qty
LOAD [Account Name],
[Customer Address 1],
[Post Code],
[Document Date],
Description,
[Line Qty]
FROM

(txt, codepage is 1252, embedded labels, delimiter is ',', msq);

topic Re: Remove multiple columns with filter while Load data - Syntax in QlikView

Remove multiple columns with filter while Load data - Syntax

Re: Remove multiple columns with filter while Load data - Syntax