End of Custom Filter Not working

Hello,

I have an issue where I am trying to filter for certain account numbers in a dataset, and I was using this filter with an earlier version of the input file and now that I have had to change the input file I am running into issues, mainly being that the formulas seem to fail when I add the quotation mark to the end of the last account number in the list. If I leave it without the second quotation mark on the last account number in the list it will return an unmatched operator error for that character, but the rest of the filter works correctly. When the quotation mark is added the whole filter turns black. I've been stumped researching and trying to fix this since I did not have this issue with the filter until I changed the input data.

Thank you for any help

Screenshot 2024-08-22 133007.png

Screenshot 2024-08-22 133051.png

Datasets

Error Message

Custom Tools

Help

Accepted answers

alexnajm

[Account] is now likely coming across as a number - change it back to a string with a Select tool beforehand and you should be good to go

All comments

alexnajm

[Account] is now likely coming across as a number - change it back to a string with a Select tool beforehand and you should be good to go

Bren_Spill2

@kohallo1 - looks like the data type for account changed from string to numeric?

You should consider another approach for filtering here - try adding the accounts you want to filer on to a tex tinput tool, then join it to the main data stream on the Account field. Anything coming out of the J anchor will essentially be your filter

OTrieger

I believe that you have the resolution above, however next time there is an easier way to set the filter, will make your life easier for future:
You can set the following:
[Account] in ("a","b","g") for string or [Account] in (1,2,3) for numeric

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703