SOLVED
Generate rows based on periods in columns
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
fredrikw
6 - Meteoroid
‎09-13-2019
06:13 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I need help on how to achieve this in Alteryx. Anyone that knows how?
Create table 2 based on table 1:
Table 1
Customer name | Period 01 2019 | Period 02 2019 | Period 03 2019 |
A | 3,14 | 6 | 8,5 |
B | 1 | 2 | 3 |
Table 2
Customer name | Period | Value |
A | 01 2019 | 3,14 |
A | 02 2019 | 6 |
A | 03 2019 | 8,5 |
B | 01 2019 | 1 |
B | 02 2019 | 2 |
B | 03 2019 | 3 |
Solved! Go to Solution.
Labels:
- Labels:
- Help
4 REPLIES 4
JosephSerpis
17 - Castor
‎09-13-2019
06:17 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @fredrikw you can use the transpose tool to produce the output you describe.
‎09-13-2019
06:28 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @JS420, thank you so much! 🙂
JosephSerpis
17 - Castor
‎09-13-2019
06:30 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
your welcome @fredrikw I amended the workflow slightly to remove period from the name column.
‎09-13-2019
06:34 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Your'e too kind, thanks! 🙂