True/false

Question

Hi. See below the following table. How would one go about creating a flow which produced the column Istrue as output.

AccountProductIsTrue1

A01B01C02A13A13A14B04C0

So there is 4 scenarios as illustrated above.

1 account with 1 product A, and no other products attached, should output 1.

1 account with multiple product A's, and no other products attached, should output 1.

1 account with product A as well as B /& C should output 0.

1 account with product B/&C should output 0.

Thanks in advance.

JamesCharnley · Accepted Answer

Hi @juliussorensen ,

This would work for your example but would obviously need some slight changes if the products are called something different. It might not be the cleanest but should work. It's using a combination of the regexmatch and contains functions to find your relevant tags.

Let me know if you have any questions.