Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Parse Error Using Customer Filter

ldean
8 - Asteroid

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

21 REPLIES 21
atcodedog05
22 - Nova
22 - Nova

@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
22 - Nova
22 - Nova

Happy to help 🙂 @ldean 

 

Cheers and Happy Analyzing 😀

Labels