How to use Alteryx to create a flat file?

[HJ735]

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!

[AngelosPachis · Accepted solution]

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

[HJ735]

Thank you!