1 Reply Latest reply on Nov 1, 2018 9:17 PM by swaroop.gantela

    Splitting Strings into Individual Rows and Using as a Filter

    Matthew Hefferon

      Hello Tableau Community!

       

      I have a data set that contains a string. I wrote Regex to parse out the string and get its keys and values:

      Screen Shot 2018-11-01 at 11.26.00 AM.png

      Next, I need the keys and values to be on individual rows and not a comma-separated list. I found this awesome thread CROSS JOIN with Tableau's join dialog from kettan and was able to get the keys and values as individual rows:

       

      Screen Shot 2018-11-01 at 11.29.41 AM.pngScreen Shot 2018-11-01 at 11.29.51 AM.png

      Here is my issue. I need to use the key and values as a quick filter but it looks like I can't apply both filters without screwing up my data. You can see that all the key and values aren't coming through:

       

      Screen Shot 2018-11-01 at 11.33.09 AM.png

       

      Attached is a sample workbook.

       

      Thanks in advance for any feedback and advice!