Workflow - Combining 2 excels data

gavinloi

Hi all,

I am trying to create a workflow to combine 2 sets of data into 1 and removing the spaces and null value in-between.

I would want to copy the data from "Test 2" and paste it into "Test 1"

Would this be possible ?

Test 1

Test 2

Final outcome

Thank you!

Test 2.xlsx

Test 1.xlsx

Workflow

Power BI

Accepted answers

atcodedog05

Hi @gavinloi

Here is how you can do it.

Workflow:

1. Using filter tool to filter null rows

2. Using dynamic rename to fix name and get it to similar format.

3. Using union to union on name. Set output order.

Hope this helps : )

Excel data merge.yxmd

messi007

@gavinloi,

You can do it with join tool tool with Auto config by position and output order

Attached the workflow.

Hope this helps !

Regards.

Union_20210903.yxmd

All comments

atcodedog05

Hi @gavinloi

Here is how you can do it.

Workflow:

1. Using filter tool to filter null rows

2. Using dynamic rename to fix name and get it to similar format.

3. Using union to union on name. Set output order.

Hope this helps : )

Excel data merge.yxmd

messi007

@gavinloi,

You can do it with join tool tool with Auto config by position and output order

Attached the workflow.

Hope this helps !

Regards.

Union_20210903.yxmd

gavinloi

@messi007 @atcodedog05 Thank you both! It worked wonders. Have accepted as solutions as well. Thank you!

amitpanchal19

against Text 2 use select tool to rename column to match Text 1
using union tool combine both data by name
using filter tool, filter out any column required using formula "!IsNull(x)"
Give output to your required format

atcodedog05

Happy to help : ) @gavinloi

Cheers and have a nice day!

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703