merging two similar data sheets and adding columns

[jer11013]

Hello!

I am trying to join/union two different Excel sheets with very similar formats. One is for 2020 and one is for 2021, but the data is very similar (column headings..etc.)

Right now I am using a join. Taking all data from 2021 and only the unique ID number from 2020. I renamed the 2020 unique ID "20 Unique_ID". 

I am sending this to a formula to add columns to 2021 data I am adding and Additions column so if the number was in 2020 and 2021 data set I want it to return a "no" and if it is new to 2021 return a "yes". Don't know if a union would be better here or different logic in formula.

if [Unique_ID] = [20 Unique_ID] then
"no" else "yes"
endif

Any help would be appreciated! 

[atcodedog05]

Hi @jer11013 

Can you provide some sample input and expected output It will help us get a better understanding of the usecase.

We will be happy to help : )

[jer11013]

2020 Unique IDs

100000366221

100000366222

100000366223

100000366224

100000366225

2021 Unique IDs

100000366221

100000366226

100000366227

100000366224

100000366225

I would want to add columns to 2021 data. I would expect Additions column to return a "yes" for Unique IDs 

100000366226

100000366227

and a "no" for

100000366221

100000366224

100000366225

[binuacs]

@jer11013 

[atcodedog05]

Hi @jer11013 

Here is how you can do it.

Workflow:

Hope this helps : )