1 Reply Latest reply on Jun 19, 2018 5:47 PM by swaroop.gantela

    Join on multiple conditions using visual interface

    Sean Morris

      Hi all. I'm trying to do something so simple that I think I might be missing something obvious. I'm trying to join a text file to two other tables (address and name) and only want to keep rows from the original text file that match on BOTH address and name from the other tables. I typically use the visual interface for joining tables (not SQL), but I can't figure out how to do this. As far as I can tell, I can only join in such a way that resulting dataset includes all rows that match on name OR address. Is this clear?

       

      Below is a screenshot of my current join.