Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

How to use Alteryx to create a flat file?

HJ735
5 - Atom

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 LocationTotal countLocation 1Location 2Location 3Location 4
Location A100730
Location B1510005

 

I want to create an Alteryx workflow to transform the data into a flat-file that would look something like this:

Starting LocationTotal countFinal Location
Location A7Location 2
Location A3Location 3
Location B10Location 1
Location B5Location 4

 

Any idea where to start? I have some experience with Alteryx but haven't touched it in a while. Thanks!

2 REPLIES 2
AngelosPachis
16 - Nebula

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

 

AngelosPachis_0-1637021765111.png

 

HJ735
5 - Atom

Thank you!

Labels
Top Solution Authors