Hi! I have a field in may dataset: names like “Susan Rodriguez”, “Samuel Smith”, etc. I need to create a filter to look with various key works ex: Sus, Smith, Br, etc. Having a normal dropdown filter an use Select All doesn’t work on my case cause Quicksight has a 1000 values max that can be show on the filter so it only selects up until 1000 which is not correct.
I have two approaches so far:
Create a string single value parameter and make the user type by separated commas (ex: Sus, Smith, Br) and use a calculated field like:
contains(nameField, split(${parameterSingleString}, “,”, 1), CASE_INSENSITIVE) OR contains(nameField, split(${parameterSingleString}, “,”, 2), CASE_INSENSITIVE)
I get the error: At least one of the arguments in this function does not have correct type. Correct the expression and choose Create again.
Create a multi value parameter with control options set to text field multiline separate values by commas. Use a calculated field like:
contains(nameField, [${parameterMultiline}], CASE_INSENSITIVE)
I get the error: Expression {{argumentName}} for function {{functionName}} has incorrect argument type {{incorrectArgumentType}}. Function syntax expects {{functionSignature}}.
How do I use the contain function correctly? I think the problem is both split(${parameterSingleString}, “,”, 2) and ${parameterMultiline} are String arrays but I don’t know how to fix this. (I’ve tried toString) Is there a different approach or way around it?
Please help! 