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.
