Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

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