1 Reply Latest reply: Feb 14, 2018 8:05 AM by Hamza Sayed RSS

    Remove multiple columns with filter while Load data - Syntax

    Alexander Timeev

      Hi!

       

      I'm trying to Load cross table

      with a script by KostinSergey

      from this thread  How to load a cross table with two headers?

       

      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 ?