Dear Community,
I am quite new to Tableau and I encountered the following problem: From a data source I get a column with 1 or more comma seperated values per row. I want to build a filter on this column which selects rows where any of the selected values occurs.
To be more clear, the column I want to filter on ("Filter_Column") looks like this:
The values of the filter should then be: (only) A, (only) B, (only) C and (only) D (and not e.g. B,C as 1 option).
It should be possible to select more than 1 option. For example if B and C are selected in the filter the following rows should be selected:
The optimal solution would be if the filter options would be data-driven, so if there was a "E" in the data, it should be automatically included as a filter option.
I am using Tableau Desktop 2020.4
Thanks in advance for your help!
Please refer to the following which details the process of splitting and pivoting data: Split & Pivot Comma-Separated Values. This shows how to do it in Desktop and Prep (which is much easier).
