Hello all,
I have two excel sheets. In both excel sheets there is several data, but they both have two certain data that are the same, which is the personal id number and year started. The first sheet has much more data than the other, but all the data in the second sheet can be found in the first one. I want to basically check if I can find the personal ID and date from every row in the second to the first, and add a column at the end of the first stating if found or not. Is there a way to do so? Let me explain with a table.
Data 1
Personal ID | Year Started |
0001 | 2010 |
0001 | 2011 |
0002 | 2013 |
0005 | 2014 |
Data 2
Personal ID | Year Started |
0001 | 2010 |
0005 | 2014 |
Output
Personal ID | Year Started | Both? |
0001 | 2010 | Yes |
0001 | 2011 | No |
0002 | 2013 | No |
0005 | 2014 | Yes |
Anyone can help?
Solved! Go to Solution.
Hi @pablomtz28, you could join the two datasets on Personal ID and Year Started to compare the datasets and write a formula tool downstream to get your Both? column flag. Something like the attached solution.
Nice! I am fairly new to Aldryx, and this helped me a lot. Thanks!