3 Replies Latest reply: Sep 12, 2017 5:11 AM by Yaniv Ben Malka RSS

    Reading a column with 'List' data type

    Yaniv Ben Malka

      Hi,

       

      I am trying to pull data from a table that has one column that hold data from 'list' type. Other columns are from 'string' type.

       

      List is represented a string delimited by a comma.

       

      Is there a simple solution to pull all values in list to the same field, and duplicate the whole line for each value?

       

      I will provide an example:

       

      Input:

      UserCodeNameEmail
      YANIVB,YANIVBM,YANIV123Yaniv Ben-Malkayaniv@123.com
      OMEROmer Shakedomer@123.com


      Requested Output:

      UserCodeNameEmail
      YANIVBYaniv Ben-Malkayaniv@123.com
      YANIVBM
      Yaniv Ben-Malka
      yaniv@123.com
      YANIV123
      Yaniv Ben-Malka
      yaniv@123.com
      OMEROmer Shakedomer@123.com