I want to select only values that are between Jan and latest month end of current year

Question

I have a dataset with Period spanning across many years but I want to select only those values that are between January and Current month - 1 for current year. Example if users runs the query on September 11,2024 then the workflow should only pick values between period JAN-24 to AUG-24. The period_name column which tells us month and Year is in V_W String format so help me build a workflow that could help me filter string column and help me get values between January and Current month - 1 for current year. It would be great if someone could help me. Thank you.

select_values_from_jan_to_current_month-1.xlsx

OTrieger · Answer

@Jully333gill 
Almost all the queries that are posted on the community channel can be solved with Python tool, as you can program it as you wish.

The above query can be easily handled with the use of Alteryx tools without the use of Python. I think that in general the aim of Alteryx is to find a way to solve these issues without coding, Nevertheless I do agree with you, Python tool is a very powerful tool when having some basic knowledge in Python.

OTrieger · Answer

@srk0609 
Parse the string date into date format and then use formula tool to create flags for the needed date with DateTime functions. And then filter the data based on these flags. 
Why flags as these will keep change from month to month and will give you a dynamic way how to map you data.