Parse Error Using Customer Filter

[ldean]

Dear Alteryx Community,

I am new to Alteryx and am trying to use the custom filter to get alteryx to choose data where the record id equals Customer_id or Customer_Postcode or Store_id or Annual_visits or Avg_Spend_GBP.

The parse error is at character 11 which is the first equals sign. The error says "Invalid Type in Operator ==."  I don't understand what I am doing wrong.

I would appreciate any help you can give.

Lisa

[atcodedog05 · Accepted solution]

@ldean 

So basically logic expands like

RecordID =  2 or RecordID = 4 or RecordID = 6 or RecordID = 8 or RecordID = 10

Shorted to

RecordID in (2,4,6,8,10)

So we are checking whether Record is one among the values in brackets.

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

[atcodedog05]

Happy to help 🙂 @ldean 

Cheers and Happy Analyzing 😀