Alteryx Designer Desktop Discussions

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

Macro Dynamic Select

BRRLL99
11 - Bolide

Hi

 

I have following data

 

G/LG/L Acct
100House Keeping Charges -  General
101Consumption of tools and Spares
102Maintance Expenses - Others
103House Keeping Charges -  General
104Consumption of tools and Spares
105Maintance Expenses - Others
106House Keeping Charges -  General
107Consumption of tools and Spares
108Maintance Expenses - Others

 

I have used Formula Tool to get the output:

Formula used :

 IF Contains([G/L Acct ], "HouseKeeping")
THEN "House Keeping"
ELSE "R&M"
ENDIF

 

I'm looking build a macro tool where I can have drop down list , in the above formula it is shown

THEN "House Keeping" .. I would like to replace it with "House marking" or "Dashboard " and so on

ELSE "R&M" I would to replace it with "A&B" and so on

I would like to have end user to select from drop down of lists.

 

G/LG/L AcctResults
100House Keeping Charges -  GeneralHouse Keeping
101Consumption of tools and SparesR&M
102Maintance Expenses - OthersR&M
103House Keeping Charges -  GeneralHouse Keeping
104Consumption of tools and SparesR&M
105Maintance Expenses - OthersR&M
106House Keeping Charges -  GeneralHouse Keeping
107Consumption of tools and SparesR&M
108Maintance Expenses - Others

R&M

1 REPLY 1
Christina_H
14 - Magnetar

Here's a basic macro that will replace the values in your formula with others selected from a dropdown

Christina_H_0-1676278326063.png

 

Labels