True/false

[juliussorensen]

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

Account	Product	IsTrue
1	A	0
1	B	0
1	C	0
2	A	1
3	A	1
3	A	1
4	B	0
4	C	0

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 solution]

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.

[juliussorensen]

Thank you so much for the swift solution :) It's working