This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
The 2022.1.1.30569 Patch/Minor release has been removed from the Download Portal due to a missing signature in some of the included files. This causes the files to not be recognized as valid files provided by Alteryx and might trigger warning messages by some 3rd party programs.
If you installed the 2022.1.1.30569 release, we recommend that you reinstall the patch.
I hope you can help me set up an automated filter for my workflow which is updated daily.
My data is processed daily which adds current FY 2021 and the current and prior FM (FM 2 and FM 3). My database looks as follows:
If I run my Alteryx WF then FY 2021 and FM 2 and FM 3 will result in duplicated data. Thus, I want an automated filter in my WF to remove the highest FY (2021) and to this year related two highest FM (FM 2 and FM 3). It should not touch/filter any FM related to FY 2020 (FM 7 and FM 2 from FY2020 should not be filtered out).
Result wanted in Alteryx WF: Filter out FY2021 and FM2 and FM3 from dataset (last two rows in table above), then load FY2021 and FM2 and FM3. It should look like this after filtering:
Hey @eb7 - I’m guessing this needs to be dynamic and the live data/WF is way larger? If not then you could of course just use a sample tool and select the ‘First N Rows’ where N = 4. If not, I’ll build something out when I hop on my laptop if nobody is else has got to you with a solution!
EDIT: Certainly not the prettiest, but seems to get the job done.
when testing by adding FM 1, 2, 3, 4, 5 then only FM 1 is left in the data base after filtering (I guess due to Min_Month step?). So, four months are filtered out. But your models are great in general. Thank you!