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

[ldean]

Thanks its not working because there are more 2000+ columns so the data I showed was just from the first column.

[atcodedog05]

@ldean 

2000 columns or rows?

[TheOC]

hi @ldean 

if you attach your workflow/input data to a comment on here, and screenshot the task that you need to do/give an example output, i'd be happy to work on this for you!

[ldean]

I think I need it to return the data (numeric) underneath the ids Customer_id, Customer_postcode etc.

[ldean]

This is the assignment I need to do. It's not very clear. I just need to understand what I am doing wrong using that filter as the instructor used it and I should too.

[atcodedog05]

Hi @ldean 

At this step

This is the formula they are refering to

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

[TheOC]

hi @ldean 

Any closer for you?

attached is the workflow

[ldean]

This sort of works but I still have a parse error. This time  at character 10. I don't understand this.

[atcodedog05]

Screenshot please.

[ldean]

Thank you so much this one worked! Could you explain why you put the rows in apostrophes? (2,4,6,8,10)