Merge Multiple Columns into one Column

Follow

Bhagirathi Anand

• March 31, 2016 14:13

0

• Official comment

  

  Joel Stewart

  • March 31, 2016 15:16

  I am unsure that I fully understand the expected result. However, based on the title of this post, I believe that you are interested in the COALESCE function in Datameer. 

  If that does not answer your question, could you please share a bit more detail about your expected results from the example in the screenshot?

  Comment actions Permalink
• 

  Adam Morgan

  • March 31, 2016 15:13

  Nice. What formula did you use?

  0

  Comment actions Permalink
• 

  Jason Arrigo

  • March 31, 2016 15:16

  Wait. Do you want to Merge Multiple columns into one? CONCAT them? replace values? Make a LIST column? Or are you just showing off? :D

  1

  Comment actions Permalink
• 

  Frances Angulo

  • April 01, 2016 13:17

  @Adam Morgan I believe Jason is referring directly to the CONCAT function. If an aggregate precedes the concatenation request, GROUPCONCAT can be used. That will provide the following results: 

   

  From separate column values: 

  | Column A | ColumnB | Column C |  

  To a list value in a single column: 

  [ColumnA,ColumnB, ColumnC] 

  The value will be returned as a LIST type and you can reference individual items using the LISTELEMENT function and an index starting at 0. 

  0

  Comment actions Permalink

Please sign in to leave a comment.