Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask 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
binuacs
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