Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

sashatim
New Contributor

Remove multiple columns with filter while Load data - Syntax

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 ?

1 Reply
qlikuser2468
New Contributor

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

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);