We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun 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