Split a dimension into multiple fields

0 votes
How to split a dimension into 2 name into first name and last name?
Apr 1, 2019 in Tableau by sindhu
763 views

1 answer to this question.

0 votes

Hi, 

Follow these steps to divide field into multiple fields. I have used country to demonstrate you the working of code.

1. Create calculated field as first-name and last name by using split function(). 

   

   Similarly do for first name by writing 1 instead of 2.

Here index 1 indicates the first word or string before split and so on.

2. Now add these 2 column next to actual field to see the date and time separately.

Hope this helps you.

answered Apr 1, 2019 by Cherukuri
• 33,010 points

Related Questions In Tableau

0 votes
1 answer

How to split or divide the grouped data into multiple graphs?

One of a simple approach is to ...READ MORE

answered Apr 17, 2018 in Tableau by xyz
• 1,560 points
269 views
0 votes
0 answers

How can I convert a dimension into a measure in Tableau

I'd like to ask a technical question ...READ MORE

Mar 31 in Tableau by Vaani
• 5,040 points
45 views
0 votes
1 answer
0 votes
1 answer

How to create a bar graph for two fields with same value?

I believe you want to have something ...READ MORE

answered May 29, 2018 in Tableau by Atul
• 10,230 points
291 views
0 votes
1 answer

Filtering in Tableau by combining multiple fields

Try This Create 3 parameter Start Date End Date City Now Create a ...READ MORE

answered Aug 30, 2018 in Tableau by Atul
• 10,230 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,230 points
7,955 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
788 views
0 votes
1 answer

compare measure/dimension values from clicking on a map?

Hi, Follow below steps: 1. Create a sheet containing ...READ MORE

answered Apr 1, 2019 in Tableau by Cherukuri
• 33,010 points
131 views
0 votes
1 answer

How to show a chart with only a part of the dimension/measure value.

Hi Nithin, Follow below steps: 1. Create a calculative ...READ MORE

answered Apr 2, 2019 in Tableau by Cherukuri
• 33,010 points
167 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