Hi,
I am trying to filter data from an excel file for a certain month. I currently filter for the string data in a column with YYYYMM format manually using the filter tool.
Is there a way for when I run the workflow to automatically pick up say the current month's data? E.g If I ran this in March 2021, I would only see data for 202103?
YearMonth | Date |
202101 | 1/29/2021 |
202101 | 1/29/2021 |
202102 | 2/26/2021 |
202102 | 2/26/2021 |
202101 | 1/29/2021 |
202101 | 1/29/2021 |
202101 | 1/29/2021 |
202101 | 1/29/2021 |
202102 | 2/26/2021 |
202102 | 2/26/2021 |
202102 | 2/26/2021 |
202102 | 2/26/2021 |
202101 | 1/22/2021 |
202101 | 1/22/2021 |
202102 | 2/10/2021 |
202101 | 1/29/2021 |
202101 | 1/29/2021 |
202101 | 1/29/2021 |
202101 | 1/29/2021 |
202102 | 2/26/2021 |
202102 | 2/10/2021 |
202102 | 2/26/2021 |
202103 | 3/18/2021 |
Solved! Go to Solution.
use this formula in your filter, assuming yearmonth is a string
yearmonth=datetimeformat(datetimenow(),'%Y%m')
if it's not a string, you can use tostring or tonumber functions
Thank you for the super fast response.
Hola, podrias ayudarme porfavor!
Necesito que Alteryx, automaticamente reconozca el mes actual y sume los valores del mes actual.