Constant

Hi all,

I'm working on a workflow where I’d like to define several user constants to make it easier to maintain — especially when we need to update things like legal entities or captions to include or exclude.

The goal is to centralize these filters using constants instead of hardcoding values in multiple tools.

Here’s an example of the filter logic I’m currently using in several steps:

[Caption] IN
("2610", "2620", "3410", "3430", "3450", "4310", "4320", "4330", "4734", "4760", "4770", "4780", "4310", "6910", "6911", "6920",
"6921", "6930", "6931", "6940", "320L")
AND
[Entity] NOT IN ("8700", "8759", "8760", "8761", "8790", "8791", "8797", "8803", "8809")

I’m trying to build constants for these lists (captions and entities), but so far I’ve only managed to get it working with one entity and one caption at a time.

Has anyone found a clean way to store and reuse these kinds of multiple-value filters using constants?

Any help or example would be greatly appreciated!

Thanks in advance

Datasets

Accepted answers

All comments

aatalai

@JorgeTB I'm not 100% sure what the ask is, but I'm guessing it is that users put in a list captions and entity and you want to create a filter statement based on that? If so this is how I did it.

I created the filter statement concentrating using the summaries tool the two list sources, then unionid them and concated the two statements and fed it to a batch macro that the filter statement dynamically updates/

Please let me know how you get on

Screenshot 2025-07-10 140704.png

dynamic filter workflow.yxzp

JorgeTB

@aatalaithanks a lot for the quick reply, I will try to use your example. looking at your flow in the snapshot can you explain why I don´t see any symbol in the last icon??

aatalai

@JorgeTB it's a macro, I've also attached the workflow for you so you could use that without needing to rebuild it

JorgeTB

Call me stupid but how can I point this in a formula what do I need to write

Currently I have this

[Caption] IN
("2610", "2620", "3410", "3430", "3450", "4310", "4320", "4330", "4734", "4760", "4770", "4780", "4310", "6910", "6911", "6920",
"6921", "6930", "6931", "6940", "320L")
AND
[Entity] NOT IN ("8700", "8759", "8760", "8761", "8790", "8791", "8797", "8803", "8809")

What do I need to write to call the Macro

thanks again for your help chatgpt wasn´t able to help me lol

dataguyW

I'm not sure if you are trying to reuse the constant just within this one workflow, or across multiple workflows and/or user across your org. If it is just in this workflow, you could try using the WorkFlow - Configuration --> Workflow and use the "+" to add a new constant variable. This would be your list of values "1", "2", "3" These are then available in your formula and filter tools under the "X" which shows fields in the Constants section. This could work for one workflow.

aatalai

@JorgeTB thanks for your qs, in the workflow I attached in the original post it does that via a control parameter, please let me know if you need any further information, you can also find more info about macros here https://community.alteryx.com/t5/Interactive-Lessons/tkb-p/interactive-lessons/label-name/Macros

Quick Links

Unanswered
Community Events
Groups

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703