SOLVED
Grouping data from a table
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
ANANDPRABHU
6 - Meteoroid
‎07-21-2021
10:54 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi Team, I need help with an Alteryx workflow for the following input and output as listed.
Input:
COL1 | COL2 | COL3 | COL4 |
235 | 636 | 235 | 365 |
652 | 896 | 456 | 326 |
896 | 999 | 777 | 555 |
333 | 555 | 333 | 44 |
Output: (can be any order)
235 |
636 |
235 |
365 |
333 |
555 |
333 |
44 |
652 |
896 |
456 |
326 |
896 |
999 |
777 |
555 |
Solved! Go to Solution.
Labels:
- Labels:
- Alteryx Practice
2 REPLIES 2
22 - Nova
‎07-21-2021
10:56 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @ANANDPRABHU
You can use Transpose tool to convert columns to rows.
Workflow:
Hope this helps : )
‎07-22-2021
05:04 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks All, it worked.
