I have 2 Excel worksheets that I would like to join. The first file has 4872 rows and the second has 158 rows. On the first file, I need to add the data from the second file on the matched rows, but also need to keep the all rows on the first file that don't have a match.
Every time I try to join the file, I end up with only 158 rows after the join. Is there another way to combine that data? Outside of Alteryz, we are using a vlookup, but I would like to have it all in the workflow.
