Advent of Code is now back for a limited time only! Complete as many challenges as you can to earn those badges you may have missed in December. Learn more about how to participate here!
Alteryx Designer Desktop Discussions
Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
Hi all,
I have been trying to resolve something for a few days now and still can't figure it out. I have a workflow that generates a lot of different financial data aggregated like:
My mission is to generate a 0 rows for the missing months for each client between Jan-16 to Mar-24. (Same as the highlighted rows)
@angel0v89 here is my method for padding the data for each customer from any start date added to the text input tool. It dynamically finds the current month when you run the workflow so it will continue to add more rows as needed. I also use the Data Cleansing tool to replace any Null values with Zero.
