Calling all Alteryx customers: Refer your colleague to try Alteryx and receive a $50 gift card. Sign up now!

Alteryx Designer Desktop Discussions

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

How to combine data in one cell?

zqlcancer
8 - Asteroid

Is there any tool available to help user combine data in different cells in one cell based on specific data? e.g. in my example, I would like to combine the different ‘Customer Email’ for each sales?

 

zqlcancer_0-1652950900452.png

 

5 REPLIES 5
IraWatt
17 - Castor
17 - Castor

Hey @zqlcancer,

A summarize can achieve that:

IraWatt_0-1652951172508.png

You can group by your sales category and concatenate the emails for each category with a ";" separator.

HTH,

Ira

 

gambiera
6 - Meteoroid

The Summarize tool can do this, as below (choose 'group by' on the sales field and then 'concatenate' on the email field):zqcancer-solution-AG.png

AlexEntz
8 - Asteroid

Hello,

 

this is easily achievable using the corss tab tool with this configuration:

 

AlexEntz_0-1652951865579.png

 

zqlcancer
8 - Asteroid

Hi guys, thanks for sharing.

IraWatt
17 - Castor
17 - Castor

No worries @zqlcancer! glad it worked for you 

Labels
Top Solution Authors