Hi @XIN WANG? , thank you for your question.
When using the 'filter rows' transform with the 'is one of' condition, you should use either numeric values or string format.
A string format needs to be inside single\double quotes.
For example, trying to filter on 'Disappointment Cleaver':
When you want to filter by multiple values, you should hit enter\tab, and a new value field will appear below the current one. There, you write your next value to filter by.
As you can see, you don't need to insert a list or an array of values; each value is written beneath the other.
Where an array is needed, Trifacta will ask for it explicitly. E.G., in the MERGE() function:
This function asks specifically for an array as its first and only parameter.
As an alternative solution to filtering by multiple values, you can also use Trifacta's interactivity and select all the desired values through the data grid or the histogram. By selecting multiple values in the same column, Trifacta will adjust its suggestions accordingly:
However, instead of using the filter transform - it will use the MATCHES() function - and insert a trifacta pattern with an or ('|') pipe to list all the possible values you've selected:
I hope that makes sense; please feel free to ask any additional questions.
Thanks,
Amit.
