Yours was an innovative approach, but I fear the culling down to the correct IDs
will require quite a bit of parsing (please see an example in the attached, Sheet2).
Did want to seek clarification on how your users will be entering in desired IDs.
Will they submit to you lists of comma separated strings that you will incorporate into parameters?
Will there be of a predetermined amount IDs per line?
If these are known in advance, the parsing, though multistep, could work.
If the end goal is to have a user enter into a textbox the list of strings,
then I think using the "Multiple values (custom list)" option of the
filter interface should work (Sheet1).
210347mult.twbx 38.5 KB
Thanks swaroop for working on it....
Will they submit to you lists of comma separated strings that you will incorporate into parameters? -No
Will there be of a predetermined amount IDs per line? -No
The requirement is the user will be entering the values separated by a comma delimiter in the parameter (approximately 1000 id's) and they will be entering the random numbers. I know it's a challenging requirement and didn't find anything so far to resolve this in tableau...Let me know if you find any..
At some point I acheved this by going Custom SQL route and pushing parameter value though a function that returns a table (something like this). Then, use that 'table' in IN clause.
I'd have to agree with Swaroop though - "Multiple values (custom list)" filter is much cleaner.
Solution A: Calculation with Parameter
Bracket parameter and field with commas (","):
CONTAINS(","+[PObject_ID]+",", ","+STR([Id Object])+",")
Solution B: Quick Filter > Multiple Values (Custom List)