Replace delimiter from field value.

0 votes
How to replace delimiter from order id in tableau? Is there any direct function to do that?
Apr 17 in Tableau by sindhu
26 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 Sindhu,

You can use split function and then join them by using + similar to concatenate.

Follow below steps:

1. Create a calculated field to split the sub-string between delimiters with split function.

SPLIT([Order ID],'-',1)

2. Then use + to join with required delimiter.

The order-id after replacing delimiter is shown below.

Hope this helps you.

answered Apr 17 by CHERUKURI
• 13,940 points

Related Questions In Tableau

0 votes
1 answer

How to create a single calculated field from multiple column filtering?

Try with this calculated field: ( ...READ MORE

answered Jul 6, 2018 in Tableau by Atul
• 5,470 points
25 views
0 votes
1 answer

Blend two different fields from 2 tables into one field.

Hi, Follow below steps: 1. Connect to both data ...READ MORE

answered Apr 3 in Tableau by CHERUKURI
• 13,940 points
11 views
0 votes
1 answer

pie chart from a calculated field

Hi Keerthana, As you have already created a ...READ MORE

answered May 20 in Tableau by CHERUKURI
• 13,940 points
8 views
0 votes
0 answers

How to export the IdP (Identity provider) XML Metadata from Keycloak which is imported to Tableau?

Keycloak version 1.6.1, Goal: Keycloak should act ...READ MORE

Mar 28, 2018 in Tableau by Atul
• 5,470 points
263 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
946 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
+2 votes
1 answer
0 votes
1 answer

Add reference line from calculated field.

Hi, Follow these steps: 1. Create the calculated field. 2. ...READ MORE

answered Mar 29 in Tableau by CHERUKURI
• 13,940 points
15 views
0 votes
1 answer

Split date and time from datetime field.

Hi,  Follow these steps to divide field into ...READ MORE

answered Apr 1 in Tableau by CHERUKURI
• 13,940 points
55 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.