9 Replies Latest reply: Mar 3, 2014 2:46 PM by Nicole Smith RSS

    Remove columns from load by name, not position

    Nicole Smith

      I am able to remove columns from a cross table load by doing this:

      CrossTable(Field, Value)

      LOAD *

      FROM test.csv

      (txt, codepage is 1252, embedded labels, delimiter is ',', msq, filters(

      Remove(Col, Pos(Top, 2))

      ));

       

      However, this removes the column by its position in the file.

       

      Is there a way that I can specify which column to remove by the column name?  The columns that I'm importing aren't always in the same order.