In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

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