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
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
hi @maxtla
Please use the formula tool, to achieve this.
Many thanks
Shanker V
Hi @maxtla
Input:
Output:
Formula:
If you need in another way,
You can tweak the formula according to the output you are expecting.
Kindly accept this solution if it provided a solution to your question.
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
Please see my second solution, where I have explained just to add.
Its not replace.
The output is added, not replaced.
Formula: [Name]+" "+[Aggregation]
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
Yes, its possible.
Use the select tool, then unique and union tool to add the same.
Workflow:
Step 1: Input the data
Step 2: Select tool
Step 3:
Step 4: Unique
Step 5;
Output: Run to get the output
Thank you very muich!!
it really help
