7 Replies Latest reply on May 2, 2018 7:08 PM by Shinichiro Murakami

    How to split column and build a database like csv

    Isaac Tong

      Hi,

       

      Thanks for any help in advance.

      I have a csv source file with a field that has multiple items separated by space.

       

      IDAttributePOC
      ABCAttribute1 Attribute2 Attribute3

      Me

       

      How do I transpose it into the following format to build analysis?

       

      IDAttributePOC
      ABCAttribute1Me
      ABCAttribute2Me
      ABCAttribute3Me

       

      Thanks.

       

      ______ Isaac