SOLVED
How to use Alteryx to create a flat file?
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
HJ735
5 - Atom
‎11-15-2021
04:05 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi Alteryx Community,
I'm currently faced with an issue in that I have a data set which original and future locations with the future locations set as columns.
For example:
Starting Location | Total count | Location 1 | Location 2 | Location 3 | Location 4 |
Location A | 10 | 0 | 7 | 3 | 0 |
Location B | 15 | 10 | 0 | 0 | 5 |
I want to create an Alteryx workflow to transform the data into a flat-file that would look something like this:
Starting Location | Total count | Final Location |
Location A | 7 | Location 2 |
Location A | 3 | Location 3 |
Location B | 10 | Location 1 |
Location B | 5 | Location 4 |
Any idea where to start? I have some experience with Alteryx but haven't touched it in a while. Thanks!
Solved! Go to Solution.
Labels:
- Labels:
- Common Use Cases
- Datasets
2 REPLIES 2
AngelosPachis
16 - Nebula
‎11-15-2021
04:16 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @HJ735 ,
I believe step #1 would be to transpose all location fields and group by the Starting Location column. Then with a filter tool, you can exclude all original locations that have a value of 0 with a filter tool
‎11-15-2021
04:19 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you!
