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
9 views

1 answer to this question.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
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
• 13,860 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,470 points
364 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
25 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
74 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
1,912 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
• 13,860 points
11 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,200 points
919 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,200 points
36 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
• 13,860 points
15 views
0 votes
1 answer

How to install Tableau Desktop/Public in Windows?

Hey, it is a simple and easy ...READ MORE

answered Feb 27 in Tableau by CHERUKURI
• 13,860 points
22 views

© 2018 Brain4ce Education Solutions Pvt. Ltd. All rights Reserved.
"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.