Looking for help generating rows: Getting Months from Quarters

I'm wondering if anyone can provide some assistance with using the generate rows tool. I have a list that has quarters along with turnover rate for that quarter. I need to generate months for each quarter so I can join it back to part of the workflow that does turnover by month. I can't quite figure out how to use the generate row tool to accomplish this. The output should then have 3 rows(months) with format yyyy-mm-dd for each quarter.

I've attached a sample dataset if that helps.

Thanks for any help!

Crig

Help

Preparation

Time Series

Accepted answers

Though you can use the generate rows tool, I have a suggestion without it (because there is not end to the date).

Attached workflow might help you.

Best,

Yalmar

DateAdd_YM.yxzp

All comments

Though you can use the generate rows tool, I have a suggestion without it (because there is not end to the date).

Attached workflow might help you.

Best,

Yalmar

DateAdd_YM.yxzp

Use the formula tool to create date fields for beginning and ending date based on the Q value (Q1, Q2, Q3, Q4).

Then see this post from earlier today, with an example for Generate Rows:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Count-occurences-per-month-if-month-included-between-Date-In-and/m-p/397580#M73006

Works perfectly! Thanks!!

Quick Links

Tags

This months top contributors

atcodedog05 19598

Qiu 15867

MarqueeCrew 13708

apathetichell 13703