We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Columns names used inside a formula tool

msaxen2
7 - Meteor

Hi,

 

I m looking for a way to organize my workflows and an important step that i want to do is to output the name of columns created or formulated inside formula tool as annotation:

 

msaxen2_1-1571843544329.png

 

I have copy pasted few of the columns in the annotation field of the formula tool but its easy if there are few columns. I have a formula tool that has close to 50 columns and doing a copy paste of each is a way too much. Is there any easier way to do it?

 

msaxen2_2-1571843697779.png

 

 

 

1 REPLY 1
Thableaus
17 - Castor
17 - Castor

Hi @msaxen2 

 

Use the Field Info Tool after the Formula Tool and you'll have a full list of your Name Fields generated.

You can filter out by the "Source" column, using a Contains function looking for "Formula"

That way you know which fields came from the Formula Tool.

 

Cheers,

Labels
Top Solution Authors