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 

I have made the yellow highlighted changes.

Output:

You can check it from your end too.  I have attached the modified workflow.

Hope this helps 🙂

[JDong]

Hello @atcodedog05 

I think I see an issue

!IsNull([Value 1])and !IsEmpty(Trim([Value 1]," "))

Here the Value 1 column is not always empty and has some values at times and the flow needs to overwrite these values.

Can you please advise here ? Please refer to the attached updated data in the flow.

[atcodedog05]

Hi @JDong 

Is the condition like if one blank also it should overwrite. Or it should write in the blank places only.

[atcodedog05 · Accepted solution]

Hi @JDong 

Here are 2 versions.

Version 2: If either value 1 or value 2 is blank then completely overwrite row 1

Version 3: If value 1 or value 2 is blank update only that value.

Hope this helps 🙂

[atcodedog05]

Happy to help 🙂

Cheers and happy analyzing 😀