Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

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
Top Solution Authors