Joining two results back together

cowannbell

I have a table with a filter for tax ID type.  So I filter for E as the type.  I then want to see all of the records with E and all of the records with S as a type that match on Tax ID.  So the just is that I want to see rows where the TAX is listed as E and S.  I don't want the left and right on the same row, I want all left and all right on their own rows because I need to do more filtering down the line.

I can't seem to get this to work right using the Join tool.

What tool do I need to accomplish this?

Thanks,

cowannbell

You were close and got me to thinking correctly.

Here is what I had to do.

I added the record ID

I then did the select for E on Tax ID format to get E on true and S on False

I then did the join on TAX ID, this gave me the records were TAXID was listed as Both E and S type

I then used the arrange tool to combine the left record ID and the Right record ID into a new field called combined record ID

I then did the join tool to pull in the full records from the original file matching Record ID to the new Combined Record ID.  This gives me all of the records.

I was not familiar with the arrange tool.  This tool is exactly what I needed.

Thank you so much for the direction.  It got me to thinking in the right direction.