Missed the Q4 Fall Release Product Update? Watch the on-demand webinar for more info on the latest in Designer 24.2, Auto Insights Magic Reports, and more!
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