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 ffdfd
• 5,550 points
840 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,560 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, 2019 in Tableau by Cherukuri
• 33,030 points
3,870 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 ffdfd
• 5,550 points
2,942 views
0 votes
1 answer

How to use a IFF statement in Tableau

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

answered Apr 5, 2018 in Tableau by QueenBee
• 1,820 points
1,956 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 9, 2018 in Tableau by ffdfd
• 5,550 points
4,822 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
9,952 views
+2 votes
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
1,622 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 5, 2018 in Tableau by xyz
• 1,560 points
704 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,560 points
6,906 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP