3 Replies Latest reply on Jul 19, 2016 12:52 PM by Shawn Wallwork

String Values to Numeric

Muhammad Khan Jul 19, 2016 11:49 AM

Hello

I am using excel as data source, some of the numeric fields are pulled by tableau as stings and considered as dimension. is there any way to convert these stings to numeric values in tableau.

Help on the issue will be highly appreciated

Thanks

Muhammad

1. Re: String Values to Numeric

Shawn Wallwork Jul 19, 2016 12:10 PM (in response to Muhammad Khan)
Two choices:
Change them from strings to numbers in Excel
Change then from strings to numbers in Tableau

1. In Excel highlight all the affected numbers and then click the yellow exclamation point and convert them from strings to numbers.

2. In Tableau go to the Data Source page and change the data type like this:
Whichever number type you want need.

Cheers,

--Shawn
2 of 2 people found this helpful
Like Show 2 Likes(2)

Actions
2. Re: String Values to Numeric

Muhammad Khan Jul 19, 2016 12:38 PM (in response to Shawn Wallwork)

Hello Shawn

Thank you so much for helping me, it worked for me. How can I mark your answer correct ?

Regards

Muhammad
Like Show 1 Likes(1)

Actions
3. Re: String Values to Numeric

Shawn Wallwork Jul 19, 2016 12:52 PM (in response to Muhammad Khan)

Just did it for you. (I think you have to be logged in to get that option.) Glad it helped.

Cheers,

--Shawn
Like Show 1 Likes(1)

Actions

Go to original post

Tableau Community

String Values to Numeric

1. Re: String Values to Numeric

2. Re: String Values to Numeric

3. Re: String Values to Numeric

Actions

More Like This