In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests after December 31, 2025. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
Start Free Trial

Alteryx Designer Desktop Discussions

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

Merge data into single Excel output Cell

Learner09
8 - Asteroid

Hello All,

 

I am trying to copy the different cell data into one single cell. Could anyone help me to prepare a flow for the same?

Please see the attached data.

3 REPLIES 3
ShankerV
17 - Castor

Hi @Learner09 

 

Yes, you can achieve the desired output with the help of Basic table tool.

 

Many thanks

Shanker V

ShankerV
17 - Castor

Hi @Learner09 

 

Also one more way to reach the solution is via summarize tool.

 

Desired output:

ShankerV_0-1671620815930.png

 

ShankerV_1-1671620843506.png

 

ShankerV_2-1671620852387.png

 

Step 1: Input

ShankerV_3-1671620867871.png

 

Step 2 : Summarize tool

ShankerV_4-1671620899458.png

 

Step 3: Output tool.

 

If this helps, please like this post and mark it as a solution. If you have any other questions, please let us know.

 

Many thanks

Shanker V

Learner09
8 - Asteroid

thank you @ShankerV  it's worked.

Labels
Top Solution Authors