Early bird tickets for Inspire 2023 are now available! Discounted pricing closes on January 31st. Save your spot!

Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer and Intelligence Suite.
SOLVED

Joining back together two tables after splitting them with filter

Travis_Ratliff
8 - Asteroid

Hi All,

Can somebody help me with my scenario?

 

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

IDsellerbuyercontractdateproductquantityprice
T1MEMcDonalds

12354

2022-06-25burgers153.06
T2MEWendys457892022-05-14burgers495.46
T3MEIn-N-Out125462022-07-13fries627.25
T4MEJacks126542022-07-02burgers544.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.

1 REPLY 1
IraWatt
17 - Castor

Hey @Travis_Ratliff,

You are looking for the Union Tool:

IraWatt_0-1663189048242.png

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

 

Labels