How to use REGEXP_MATCH() ?

0 votes
How to use REGEXP_MATCH() to find products with same company name?. My data consists of product information like company, product name, place, expiry, manufactured date. I want to display products from many products and goods.
Apr 1 in Tableau by Nithin
31 views

1 answer to this question.

0 votes

Hi,

Create a calculated field with code like this,

Product_match

REGEXP_MATCH([Product Name],'/w*-/w*')

For example if you are searching for product Goodday-ahv5e5dsd  followed by some id, then \w is used to denote a character and * denotes 0 or more occurrences of any character.

If your product name have any special characters such as ], . ,* , $ then you must prefix with \ to make it as a normal character.

\w and \s denote words, space, for matching pattern.

Hope this helps you.

answered Apr 1 by Cherukuri
• 31,840 points

Related Questions In Tableau

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
703 views
0 votes
1 answer

How to use tableau to searh for text within entire data

You can use a pivot table in ...READ MORE

answered Apr 4, 2018 in Tableau by xyz
• 1,550 points
65 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
187 views
0 votes
1 answer

How to use LOD to count distinct number of records based on some condition?

From the desired output it seems that ...READ MORE

answered Apr 9, 2018 in Tableau by xyz
• 1,550 points
5,621 views
0 votes
1 answer

What is the difference between REGEXP_MATCH() and REGEXP_EXTRACT()?

Hi, REGEXP_MATCH() AND REGEXP_EXTRACT() are both used for ...READ MORE

answered Apr 1 in Tableau by Cherukuri
• 31,840 points
103 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,191 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
98 views
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
• 31,840 points
60 views
0 votes
1 answer

How to use stored procedures in Tableau?

Hi Sindhu, Stored procedures are used to write ...READ MORE

answered Jun 10 in Tableau by Cherukuri
• 31,840 points
368 views