This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I am trying to join sheet A (4395 rows) and sheet B (4824 rows) together, the alterlyx join only returns all matched rows, in this case the result is 3716 rows. What I want is return everything in sheet A, so the result should be 4395 rows, just like the excel vlookup. Anyone knows how to do this?
I just tried but the row numbers it returns is matching the right sheet, not the left one. I tried to do a filter (primary key is not null) after the union but this returns the same result as join. So it still doesn't work as expected.
To keep all values from sheet A and the joined values from sheet B you would need to do a left outer join, this could be done by adding a union tool after your join and unioning the "left" (L) and "joined" (J) anchors together as seen below.
I've attached my workflow for you to download if needed. If this solves your issue please mark it as correct, if not let me know!