add column data into another column

[maxtla]

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

[DenisZ]

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.

Please mark it as solved if it solves the issue

[ShankerV]

hi @maxtla 

Please use the formula tool, to achieve this.

Many thanks

Shanker V

[ShankerV]

Hi @maxtla 

Input:

Output:

Formula:

Many thanks

Shanker V

[ShankerV]

Hi @maxtla 

If you need in another way, 

Input: 

Output:

Formula:

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]

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]

Hi @maxtla 

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

Its not replace.

Many thanks

Shanker V

[ShankerV]

Hi @maxtla 

The output is added, not replaced.

Output: 

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

Many thanks

Shanker V

[maxtla]

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]

Hi @maxtla 

Yes, its possible.

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

Many thanks

Shanker V