2 Replies Latest reply: Apr 21, 2017 2:34 AM by Ihor Ostapchuk RSS

    [QS] How to store an evaluated expression as a column name?

    Oliver Queen

      To store an evaluated expression as a field in data load editor, one can do this:

       

      Let vMonth = FileName();

      LOAD

          $(vMonth) as "Month",

          ...

          ....

       

      But how can I store the variable as a column name such that:

       

      Let vMonth = FileName();

      LOAD

          "ColumnA" as $(vMonth),

          ...

          ....

       

      where ColumnA is a field from my data source. I've played around with combinations of Set and Let and equal signs and quotation marks but to no avail.