Filtering out Month

[sgaryali]

Hi

I have dates of let's say April Month and May Month.

I want to filter out next month data like in file I have April an May month dates so I want to filter out next month which is May month dates.

And I want to keep only April Month.

How can we do that for each Month automatically like if we are running files for May month so June month dates gets Filter out.

I am attaching file for reference.

Thanks in advance.

[CarliE]

@sgaryali 

You can do the following:

1. Create a month field

2. Take the max of the months

3. Join back and continue with the left output

workflow is attached.

If this solved your problem, please make sure to mark it as a solution to help other members on the community out!

[IraWatt]

Hey @sgaryali,

How do you determine what month you would like to filter on? In my example it just filters on the current month:

Any questions or issues please ask :)
HTH!
Ira

[sgaryali]

Hi @CarliE 

Can you please share yxmd format instead of yxzp please?

[DylanDowrick]

@sgaryali a .yxzp typically has a .yxmd file with other input data files zipped with it.

[CarliE · Accepted solution]

@sgaryali 

attached :)