Joining back together two tables after splitting them with filter

[Travis_Ratliff]

Hi All,

Can somebody help me with my scenario?

I have an input with 10,000+ rows that look like:

ID	seller	buyer	contract	date	product	quantity	price
T1	ME	McDonalds	12354	2022-06-25	burgers	15	3.06
T2	ME	Wendys	45789	2022-05-14	burgers	49	5.46
T3	ME	In-N-Out	12546	2022-07-13	fries	62	7.25
T4	ME	Jacks	12654	2022-07-02	burgers	54	4.61

What am I doing in my workflow is filtering this data for dates after 2022-06-30 (end of June). So that the True would contain T3 and T4 and False would contain T1 and T2. I am doing this in order to check that the dates are correct and fix them if not. For example, only fries are allowed to have a date after the cutoff (June 30th) so I would correct that date in the input file so that when I run it again only T4 is shown in the True section of the filter. 

What I want to do is after checking that the dates are correct is to combine them back into one vertical table that would match what the table looked like before filtering just with the corrected dates. I attempted to use a join multiple but I want the table vertical and not horizontal.

Any help would be appreciated.

[IraWatt · Accepted solution]

Hey @Travis_Ratliff,

You are looking for the Union Tool:

This will append the first table you connect to it on top of the second table by default.