Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
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