I have taken all the dividend-paying stocks and used k-means to assign them to clusters. Now I would like to use a list of my personal stocks to see which clusters my stocks are in. I see a filter operator to filter a single selection like on cluster_4 but I want to filter on a LIST no a single variable.
In SQL it would look like this:
Select * where StockSym in {XOM, PRU, CVX, SPG …..}
Is there an operator I can use to filter based on my list?
Since you are trying to do a SELECT with an OR, on the bottom left corner of the Filter Examples configuration you can select "any" of these, not "all".
If by any chance you have an actual list as an example set, you can use a "Join", and make it an "Inner" join.
Since you are trying to do a SELECT with an OR, on the bottom left corner of the Filter Examples configuration you can select "any" of these, not "all".
If by any chance you have an actual list as an example set, you can use a "Join", and make it an "Inner" join.
Since you are trying to do a SELECT with an OR, on the bottom left corner of the Filter Examples configuration you can select "any" of these, not "all".
If by any chance you have an actual list as an example set, you can use a "Join", and make it an "Inner" join.