Parse Error Using Customer Filter

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

Parse Error in Custom Filter.docx

Input

Accepted answers

atcodedog05

@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 😀👍

All comments

atcodedog05

Hi @ldean

It might be datatype mismatch issue.

I have a question are you trying to compare 2 columns RecordID and CustomerID

Are you trying to compare column RecordID has value CustomerID

If you are trying to compare 2 columns it should be

[RecordID]=[Customer_id]

compare whether [RecordID] is "Customer_id"

Tostring([RecordID])="Customer_id"

TheOC

hi @ldean

This is most common when you are trying to compare a numeric field with a string. Given that your trying to compare Record ID with "compare ID" (a string). Then i suspect that your recordID is a numeric field (or not a string field).

Apply a select before the filter, and make sure that the recordID field is a string type.

MarqueeCrew

@ldean ,

I'm explicitly making everything a string. The fields all need to be either strings or numeric data types.

tostring([record id]) IN (tostring([Customer_id]),tostring([Customer_Postcode]), tostring( [Store_id]), tostring( [Annual_visits]), tostring([Avg_Spend_GBP]))

cheers,

mark

ldean

I have attached a sample of the data. I want it to read the data below the each of the record ids (Customer_id etc).

Does this help?

Parse Error Data.xlsx

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703