MODIFIED CONTAINS IN-LIST MACRO

This is a macro that @MarqueeCrew made to find an item in a list. However, the macro as it exists does not suit my purposes. I need the "Target Terms" to be an optional field in my workflow. I need to modify the macro so that if the "Target Terms" are left blank, all the records are allowed to pass. It's driving me crazy.

Thanks.

modified in-contains macro.yxzp

Custom Tools

Macros

Accepted answers

AbhilashR

@bb213 - I modified the macro to pass every record if the Target Field(s) is blank, or function as a filter if the user types-in relevant value.

Solution attached for your reference.

modified in-contains macro_Updated.yxzp

All comments

AbhilashR

Hi @bb213, judging by the macro's functionality, it looks like it filters the dataset based on the values provided by the user. Not necessarily getting into its inner workings, would the Filter tool work in what you are looking to do?

sample.yxmd

bb213

@AbhilashR What you just showed me is a simple filter. I need the macro edited to give me the functionality i described.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703