We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Help: How to remove previous month's data and keep current month and vice versa

V794821
5 - Atom

Hello, I hope someone can help.

 

I have two data set, Historical Raw and Current Raw. 

 

Historical Raw contains all of last month up to yesterday's (current month) projected and actual data while, Current Raw contains actual and projected numbers of the last few days of the previous month and the entirety of the current month including future dates.

 

I would like to ask some help if there is a dynamic way to remove the current month's data from the Historical Raw and vice versa on the Current Raw?

I have attached a sample of the raw files. 

 

Thank so much!

1 REPLY 1
binuacs
21 - Polaris

@V794821 you can setup a filter tool and only filter the current month and year from the current input file and filter out those from the historical file

image.png

Labels
Top Solution Authors