Free Trial

Alteryx Designer Desktop Discussions

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

Output tools

ArtixWinterguard
6 - Meteoroid

Hello!

I`m trying to output the field names from select tools to an excel, someone knows how do that? 

Example:

This:

ArtixWinterguard_0-1624555398627.png

To:

ArtixWinterguard_1-1624555413518.png


My objective is pick up the original name next to the renamed ones.

 

5 REPLIES 5
apathetichell
19 - Altair

field info before select - record id. field info after select record id. join on record id. output. you can rename things in the join for readability.

ArtixWinterguard
6 - Meteoroid

can u show me a example?

apathetichell
19 - Altair

as attached - also  -  I miswrote - I meant field info - not autofield...

ArtixWinterguard
6 - Meteoroid

This really helped a lot! There`s other ways to do that? Assuming more complex scripts

apathetichell
19 - Altair

Not sure I know what you mean - you attach the field infos where needed and join where needed. They could be anywhere in your workflow. You can also use a transpose to get your columns into a [name] value - but that's a bit different as it's more for transposing your actual data.

Labels
Top Solution Authors