Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

How to Merge 2 or more column data into one single row like concatenate in excel

erHemamalini
5 - Atom

 

Column1 Column2      result

10            12                1012

JF1234     34324          JF123434324

2 REPLIES 2
erHemamalini
5 - Atom

Column1 Column2    Column3    Column 4    Expected result in single column

10            12                                                   1012

JF1234     34324        15                                JF12343432415

                 23                               45               2345

 

summarized table cannot be used for this, as it is not giving expected result.   

flying008
15 - Aurora

Hi, @erHemamalini 

 

Just follow this way :

 

Spoiler
录制_2023_05_17_07_56_10_449.gif

录制_2023_05_17_10_28_38_837.gif

 

******

If can help you get your want result, please mark it is a solution and give a like for more share.

Labels
Top Solution Authors