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