Macro

[BRRLL99]

Hi Team

I have following data

A/C	Account Details
100	Civil Work
101	Civil Work
102	Civil Work
103	Equipments
104	Equipments
105	Equipments
106	Equipments
107	Tools and Spares
108	Tools and Spares

I have used Formula tool and written this Argument 

IF Contains([Account Details], "Civil work")
THEN "AA"

ELSEIF Contains([Account Details], "Equipments") THEN "BB"

ELSE "CC"
ENDIF 

I would like to create Macro tool. Where I can select Account details and output dynamically.

[binu_acs]

@BRRLL99 I think you are looking for an Analytic app where you can select or enter the Account Details .

The below post will be useful for your use case

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Dynamic-Filter-Based-on-list-of-data-v...

[binu_acs · Accepted solution]

@BRRLL99 I guess this is what you are looking for