Hi I have a table with the following raw data
| Fruit 1 | Fruit 2 | Fruit 3 |
|---|---|---|
| Apple | Orange | Banana |
| Banana | Orange | Pear |
| Grape | Orange | Pear |
and trying to shape a dataset so Tableau can display a dynamic word list of any words in the same row as the selected words (order of the words does not matter, just that another fruit appears in the same row as the selected one).
Ex. If user selects 'Grape' as first word, the 2nd word list would only should 'Orange' and 'Pear' If user selects 'Banana' (which appears in two different rows) as 1st word, the next list would show, 'Orange, 'Pear', and 'Apple' as potential associations (all words that could be in the same row as 'banana'), if the user then further selects 'Apple' as 2nd word, then only 'Orange' would appear as a potential selection for 3rd word.
Hope this all makes sense. I'm hopeful there is a way to do this without exploding the dataset to millions of rows as this dataset grows.
I've tried creating a unique word list then appending a unique Id for each row to the word but tableau is unable to filter this down. No code, just arranging small dataset in Excel and linking to tableau for experimentation.
It seems to be doable to dynamically filter if the words are selected in order but dynamically showing if they are in the same row has been a little more challenging.
Any ideas would be greatly appreciated. Thanks in advance for your help
