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
DenisZ
11 - Bolide

You can use the Formula tool and update Valor. The formula would be [Value]. 

 

Otherwise, you could also just change the name of the column to Value if you do

 

EDIT:

Please see attached workflow.

DenisZ_0-1669115083645.png

Please mark it as solved if it solves the issue

 

 

 

ShankerV
17 - Castor

hi @maxtla 

 

Please use the formula tool, to achieve this.

 

 

Many thanks

Shanker V

ShankerV
17 - Castor

Hi @maxtla 

 

Input:

 

ShankerV_0-1669115208527.png

 

Output:

 

ShankerV_1-1669115221612.png

 

 

Formula:

ShankerV_2-1669115239911.png

 

 

Many thanks

Shanker V

 

 

ShankerV
17 - Castor

Hi @maxtla 

 

If you need in another way, 

 

Input: 

 

ShankerV_0-1669115309662.png

 

 

Output:

ShankerV_1-1669115322836.png

 

Formula:

 

ShankerV_2-1669115341528.png

 

You can tweak the formula according to the output you are expecting.

 

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

 

Many thanks

Shanker V

 

 

maxtla
8 - Asteroid

Hi, 

thanks both...I did it with the formula tool, but I just replace the data from Name and Value into Aggregation and Valor....

I need to add that, not to replace...how can I achieve that?

 

Thanks

Monica

ShankerV
17 - Castor

Hi @maxtla 

 

Please see my second solution, where I have explained just to add.

 

Its not replace.

 

Many thanks

Shanker V

ShankerV
17 - Castor

Hi @maxtla 

 

The output is added, not replaced.

 

Output: 

 

ShankerV_0-1669116306088.png

 

Formula: [Name]+" "+[Aggregation]

 

ShankerV_1-1669116343130.png

 

Many thanks

Shanker V

 

maxtla
8 - Asteroid

Hi Shanker V,

thanks for your fast response...but I think I have not explained myself correctly...

I have the initial and want the result...like in the attachs...

thanks

ShankerV
17 - Castor

Hi @maxtla 

 

Yes, its possible.

 

Use the select tool, then unique and union tool to add the same.

 

Many thanks

Shanker V

Labels
Top Solution Authors