Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

Alteryx Designer Desktop Discussions

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

add column data into another column

maxtla
8 - Asteroid

Hi,

 

I want to add data from a column into another one.

Like this example:

Want to add Target into the column Aggregation, and the Value into Valor.

 

How to do this? 

many Thanks!!!

Monica

12 REPLIES 12
ShankerV
17 - Castor

Hi @maxtla 

 

Output:

 

ShankerV_0-1669117434807.png

 

 

Input:

 

ShankerV_1-1669117449853.png

 

Workflow:

 

ShankerV_2-1669117461507.png

 

Kindly accept this solution if it provided a solution to your question.

 

Many thanks

Shanker V

 

 

 

 

 

ShankerV
17 - Castor

Hi @maxtla 

 

Step 1: Input the data

Step 2: Select tool

ShankerV_0-1669117539657.png

 

Step 3:

 

ShankerV_1-1669117557050.png

 

Step 4: Unique

 

ShankerV_2-1669117575720.png

 

 

Step 5;

ShankerV_3-1669117598747.png

 

Output: Run to get the output

 

ShankerV_4-1669117617463.png

 

 

Kindly accept this solution if it provided a solution to your question.

 

Many thanks

Shanker V

 

 

maxtla
8 - Asteroid

Thank you very muich!!

 

it really help

Labels