My dataset contains records from all of 2017. There's a date column with the full date, for example: 2017-02-23. I want to filter my dataset so that it only contains records from a single month. How do I do this?
Solved! Go to Solution.
Hey there!
Give this a shot:
Keep rows [keep] on the condition MONTH(your_date_column) == 2
This will keep all of the values where you date column falls in February.
For more information on the keep transform, see here: https://docs.trifacta.com/display/PE/Keep+Transform
For more information on the MONTH( ) function see here: https://docs.trifacta.com/display/PE/MONTH+Function.
Where do I find that "keep rows" option?
Hello Toni,
Please refer to the steps below to find the "Keep rows" option,
Let me know if you would like further clarification on any of the steps above.
Happy Wrangling
Thanks everyone!