In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests after December 31, 2025. Set up your security questions now so you can recover your account anytime, just log out and back in to get started. Learn more here
Start Free Trial

General Discussions

Discuss any topics that are not product-specific here.

Getting alteryx to add all 12 months for each year listed

Destinitruth
6 - Meteoroid

Hello, 

 

If I a spreadsheet with a list of years in one column, and I want to mirror the rows but instead of the year being reflected, I want to add  months for each year. So if I have 

2022

2023

2024

2025

 

I need it to have 

2022 Jan 

2022 Feb

2022 Mar 

 

2023 jan 

2023 feb 

2023 mar 

etc... 

 

I cant seem to figure out a robust way to add the months to each year in my data. 

2 REPLIES 2
binu_acs
21 - Polaris

@Destinitruth one way of doing this with the help of generate row tool

image.png

Destinitruth
6 - Meteoroid

Thank you so much ! 100% solved my issue!

Labels
Top Solution Authors