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

atcodedog05

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 😀

Fill_.yxmd