Fill empty cells with data from second file

Hi there, I'm trying to fill in missing data into my Master File (EEO Report) with data from a second excel file (manually identified). I've tried many things like joins, find and replace, but my Output file includes data from both files, instead of just updating the blank fields from my mater file.

EEO Report.xlsx

Help

Join

Accepted answers

Loic

here is a potential solution. Join 2 files on EE ID, then Union of all 3 output anchors L, J, R to get all 12 employees. If you only want the employees in the first file then remove the union on R.

I then concatenate the pairs of Gender, Address and Ethnicity fields in each file only if the second one is null.

Let me know if that resolves it.

possiblesol.yxmd

All comments

mickala21

Here is the second file

manually identified.xlsx

john_miller9

Hi @mickala21 ,

EDIT - I realized that not all Employees were in the source file. I've updated the original workflow and included a second way to join the data as well. Either one should work.

You could join a few different ways, but here's one of them. The key here is to add a formula with the Ifnull function.

EEO Update.png

EEO Update.yxmd

Loic

here is a potential solution. Join 2 files on EE ID, then Union of all 3 output anchors L, J, R to get all 12 employees. If you only want the employees in the first file then remove the union on R.

I then concatenate the pairs of Gender, Address and Ethnicity fields in each file only if the second one is null.

Let me know if that resolves it.

possiblesol.yxmd

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703