Discussion board where members can get started with QlikView.
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 ?
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);