Copy Row Value after Union

[JDong]

Hi All,

I have a union in my flow which is a combination of 4 outputs with same data structure.

Now in the next step I want to copy over just one line value to the similar lines on the other outputs

Union 1
Column A	Column B	Value 1	Value 2	Category
Apple	Orange	0.9	1.2	1
Strawberry		0.3	0.6	1
Banana		0.7	2.2	1

Union 2
Column A	Column B	Value 1	Value 2	Category
Apple	Orange			2
Strawberry		3.3	4.3	2
Banana		1.6	3.4	2

Union 3
Column A	Column B	Value 1	Value 2	Category
Apple	Orange			3
Strawberry		0.7	0.1	3
Banana		5	4.4	3

So as we see here the  split output is as follows and I want to copy or overwrite the values for Column A = Apple and Column B = Orange to union 2 and 3 from union 1

Desired output 

Column A	Column B	Value 1	Value 2	Category
Apple	Orange	0.9	1.2	1
Strawberry		0.3	0.6	1
Banana		0.7	2.2	1
Apple	Orange	0.9	1.2	2
Strawberry		3.3	4.3	2
Banana		1.6	3.4	2
Apple	Orange	0.9	1.2	3
Strawberry		0.7	0.1	3
Banana		5	4.4	3

Thanks for the help in advance

[Emil_Kos]

Hi @JDong,

It would be easier for people on community to help you if you will provide us with the expected output. 

For me it is a little bit unclear what is the desired output. 

If you could share that would be awesome! 

[JDong]

Thanks...I just updated the question and hope it helps !

[atcodedog05 · Accepted solution]

Hi @JDong 

Here is a workflow for the approach. Hope this meets

Output:

Workflow:

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀

[Emil_Kos]

Hi @JDong,

Please find attached alternative solution:

[JDong]

Works well now ! 

@atcodedog05 one question is when the field is a V_Wstring it does not copy the values. Works fine on numeric field.

Anyway I can sort this please.

Thanks in advance !

[atcodedog05]

Sure definitely feel free

Happy to help 🙂

Cheers and happy analyzing 😀

[atcodedog05]

Hi @JDong 

It should work. Can you show a example of the issue i will be able to help you out better.

[JDong]

Hi @atcodedog05 

If the data is in this format 

Union 1
Column A	Column B	Value 1	Value 2	Category
Apple	Orange	0.90 €	1.20 €	1
Strawberry		0.30 €	0.60 €	1
Banana		0.70 €	2.20 €	1

For some reason, It does not work

[Emil_Kos]

Hi @JDong,

My solution should work for string format as well.