Analytic App - IN Statement help

[wonka1234]

Hi,

How can I filter my workflow for multiple values? I am getting 0 output when I try to filter for :  Morgan,Goldman

[Clifford_Coon · Accepted solution]

Hi, you can use a nested replace to update the placeholder, and replacing the single comma with ',' so the IN statement works.

 

 I tried it and it works for me.

[wonka1234]

@Clifford_Coon  can you copy and paste that here ? why did you use Destination?

[Clifford_Coon]

@wonka1234 ,  when you use the replace with formula, [destination] is the option the interface gives you in the expression editor (access using the three dots next tot the formula.   Attaching the one I played with.