11 Replies Latest reply: May 7, 2014 4:45 PM by Massimo Grossi RSS

    How can I merge columns/lists of data into one column or list?

      I tried this:

       

       

      CPT:

       

      LOAD  [Unique Identifier],
      [CPT_1] as CPT
      RESIDENT Claims;

      CPT:
      LOAD  [Unique Identifier],
      [CPT_2] as CPT
      RESIDENT Claims;

      CPT:
      LOAD  [Unique Identifier],
      [CPT_3] as CPT
      RESIDENT Claims;

      All the fields would appear in one list, but the search process did not work.