Skip to main content

Hey Tableau Community!

 

Any Regex experts out there? I have a string that I'm having trouble parsing. I was able to create a calculated field called "Get Key" That pulled out my key values successfully:

 

I'm having issues with "Get Values".

 

For the first record, I'm pulling Blue, Green, Red but I need Blue, Green, Red, Cat, Dog, Tesla.

For the second record, I'm pulling Blue, Green, Red but I need Blue, Green, Red, Cat, Dog,

The last record is working because there is only one value.

 

I've attached a sample workbook. Any help would be much appreciated!

 

Thanks

7 answers
  1. Oct 12, 2018, 8:25 PM

    I was able to get it figured out:

    I was able to get it figured out:I've attached the workbook in case it might be helpful for others.

    I've attached the workbook in case it might be helpful for others.

     

    Thanks

0/9000