Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Check out our powerful new search update! You can read more here. Please let us know if you have any feedback by creating a topic here.

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

Highlighted
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

Highlighted
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.

 

 

Highlighted
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

Highlighted
Meteor

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

Labels