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!

[atcodedog05 · Accepted solution]

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 : )

[messi007 · Accepted solution]

@gavinloi,

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

Attached the workflow.

Hope this helps !

Regards.

[gavinloi]

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

[amitpanchal19]

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

[atcodedog05]

Happy to help : ) @gavinloi 

Cheers and have a nice day!