2 of 2 people found this helpful
You will be able to do this by creating some calculated fields in Tableau. Right click in the data window on the left and select Create Calculated Field.
In the Calculated Field window you need to write a formula that will get the first name, this can be accomplished by looking for the underscore and truncating the [Name] string at that point using a combination of the LEFT and FIND functions. A formula such as the following should work
For last name, a combination of MID and FIND should do the trick
For the Location, the formulas will be very similar, you just need to substitute _ for ,
Hope that helps,
Thanks a lot for the quick reply.
But while using the formula i.e
It is showing error as FIND() function takes only constant or aggregate value and same for LEFT().
So when i am using the name of the column i.e Name it is not getting executed.
Thanks & Regards
Amarendu Samal Big Data and Advance Analytics Developer CMC ltd you could try doing this:
But I must warn you Amarendu Samal Big Data and Advance Analytics Developer CMC ltd that this may not work. Amarendu Samal Big Data and Advance Analytics Developer CMC ltd is the [Name] field coming from a secondary data source?
PS: Answered this one for you Dimitri.
I know this is coming many years late.
You could create a calculated field with the split function.
The split function returns a sub-string as determined by a delimiter.
So this formula returns the first name, substituting 1 for 2 returns the last name.
Same logic can be applied to the Location, you need to substitute the delimiter