How to use tableau to searh for text within entire data

Question

I have a tabular data with multiple text columns and I want to build a capability where a user can enter any word and Tableau will search that word across all columns and rows and then return all rows that contain that word. How could I build the same capability?

Just for example

This is how the data looks like-

name    hobby
abc xy  running, painting
dc zb   swimming, cooking

then create a new column, which would have each unique word in the row and repeat each row for each unique word (in that row). And then apply a filter on the new column

name    hobby                   each word
abc xy  running, painting   abc
abc xy  running, painting   xy
abc xy  running, painting   running
abc xy  running, painting   painting
dc zb   swimming, cooking   dc
dc zb   swimming, cooking   zb
dc zb   swimming, cooking   swimming
dc zb   swimming, cooking   cooking

But that would be very inefficient when my data is too big

Is there any alternate way to do this?

Answer 1

You can use a pivot table in tableau. You can use the following steps:

• Step 1: Select the filed

• Step 2: Right click and select Pivot

Finally it will look like this