How to use tableau to searh for text within entire data

0 votes

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?

Apr 3, 2018 in Tableau by Atul
• 5,530 points
70 views

1 answer to this question.

0 votes

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

  • Step 1: Select the filed

enter image description here

  • Step 2: Right click and select Pivot

enter image description here

Finally it will look like this

enter image description here

answered Apr 4, 2018 by xyz
• 1,550 points

Related Questions In Tableau

0 votes
1 answer

how to use/access Json data in Tableau?

Hi Sindhu, 1. Double click on Json on ...READ MORE

answered Mar 19 in Tableau by Cherukuri
• 32,260 points
95 views
0 votes
1 answer

How can I use Tableau to create a heatmap?

Step 1: Create an Excel Spreadsheet with ...READ MORE

answered Apr 2, 2018 in Tableau by Atul
• 5,530 points
762 views
0 votes
1 answer

How to use a IFF statement in Tableau

Use this syntax -  IIF(([Avg_sale] > [Today]),STR([Avg_sale ...READ MORE

answered Apr 5, 2018 in Tableau by QueenBee
• 1,810 points
215 views
0 votes
1 answer

How to calculate the percent of records within a group in tableau?

 You can click the measure SUM(Number of Records) and ...READ MORE

answered May 8, 2018 in Tableau by Atul
• 5,530 points
332 views
0 votes
1 answer

How to color code cells of a column based on the text value in Tableau

You can use the following steps to ...READ MORE

answered Mar 27, 2018 in Tableau by Atul
• 10,240 points
2,419 views
+1 vote
1 answer
0 votes
1 answer

Calculated filed with if-then

Below is the required code:  IF (NOT ISNULL([test2])) ...READ MORE

answered Mar 27, 2018 in Tableau by Atul
• 10,240 points
118 views
+2 votes
1 answer
0 votes
1 answer

How can I filter my data to see the results for 8 days ago?

Hey try these steps and let me ...READ MORE

answered Sep 4, 2018 in Tableau by xyz
• 1,550 points
76 views
0 votes
1 answer

How to group bins in a tableau histogram?

One of the simple way is by ...READ MORE

answered Apr 3, 2018 in Tableau by xyz
• 1,550 points
1,427 views