community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

Add all fields to Select Tool

Meteor

Dear Community,

 

I have the following section from a macro and I want to add all the new fields to the Select Tool. The issue is that the new fileds are not added to the macro. Please see attached.

 

Thank you for your help.

DAM

Alteryx Certified Partner
Alteryx Certified Partner

Sorry I am struggling to understand what you are trying to achieve 'add all the new fields to the select tool'?

Do you have an example of this macro within a workflow where your desired functionality does not work?

 

Ben

Meteor

Hi Ben,

 

I have a workflow on the server and it runs weekly. Every week it adds a new column (weeknumber).

In order to build  a total for each row I  have a crew macro: CReW_AddTotalRowColumns. The macro doesn't add automatically the new weeks I need to select them manually. Please see the attached Picture.

 

 

Alteryx Certified Partner
Alteryx Certified Partner

Okay.

 

So we can do this quite simply without the macro. The key is we want to ensure the 'dynamic or unknown fields' option is checked within the transpose tool.

 

See attached.

 

Ben

Meteor

Thank you for reply. Can you please save the workflow in 10.6, unfortunately I can't open it.

Labels