The Summer Cup has officially kicked off! Get ready to learn, connect, and compete! Complete Community engagement tasks to earn points and unlock exclusive Summer Cup badges for your profile. Learn more here!

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