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