Getting alteryx to add all 12 months for each year listed
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Destinitruth
6 - Meteoroid
‎01-23-2025
06:46 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
Labels:
- Labels:
- Alteryx Practice
2 REPLIES 2
binuacs
21 - Polaris
‎01-23-2025
07:41 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@Destinitruth one way of doing this with the help of generate row tool
‎01-23-2025
10:42 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you so much ! 100% solved my issue!
