Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Copying column name and the formula in formula tool to Excel or text file

rdeshpande
7 - Meteor

Hello

 

Is it possible to copy the column name and the formula text from the Formula tool to Excel or text file? for example, I have a new column in the formula tool "Revenue" My formula has " [Price]*[Volume]"

 

Can I export the actual text into an excel or text file so that I get the following output list?

Revenue        [Price]*[Volume]

 

Thank you

4 REPLIES 4
ArtApa
Alteryx
Alteryx

Hi @rdeshpande - You may want to try a Field Info tool:

ArtApa_0-1646792398614.png

 

ELPC
8 - Asteroid

Not exactly sure if this is what you are looking for but you can use a Transpose tool. 

 

ELPC_0-1646803358812.png

ELPC_1-1646803389707.png

 

Before: 

ELPC_2-1646803407971.png

 

After: 

ELPC_3-1646803427158.png

 

 

 

binuacs
21 - Polaris
rdeshpande
7 - Meteor

Thank you ArtApa and binuacs for your quick response, exactly what I was looking for

Labels
Top Solution Authors