Extract substring in Tableau

0 votes
So I have a number like - 1234567890. I just want 3 numbers from 4th position i.e only 456.
Apr 10, 2018 in Tableau by GandalfDwhite
• 1,320 points
4,207 views

1 answer to this question.

0 votes

Use the MID syntax in Tableau. For you it will be like this -

MID(String_dimension_name, 4, 6)

Here, 2nd value is the index or position and 3rd value is the length.


answered Apr 10, 2018 by QueenBee
• 1,820 points

Related Questions In Tableau

0 votes
1 answer

Extract Last Value as Metric from Table Calculation in Tableau?

First, a quick introduction to table calculations, ...READ MORE

answered Apr 12 in Tableau by Neha
• 8,560 points
46 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
5,326 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,186 views
0 votes
1 answer

MDX query in Tableau pivot table

You can view them here - \My Documents\My ...READ MORE

answered Apr 6, 2018 in Tableau by QueenBee
• 1,820 points
390 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,230 points
8,049 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,230 points
817 views
+2 votes
1 answer
0 votes
1 answer

Reset filters in Tableau

I understood your question (I hope so!). ...READ MORE

answered Mar 30, 2018 in Tableau by QueenBee
• 1,820 points
3,101 views
0 votes
1 answer

Dropdown to change x-axis in Tableau

You need to create a  str datatype parameter ...READ MORE

answered Apr 4, 2018 in Tableau by QueenBee
• 1,820 points
528 views
webinar REGISTER FOR FREE WEBINAR X
Send OTP
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP