Remove = Sign from number column and changed type

[learner03]

How can I remove = sign from these below columns and changed the data type from text to whole number or decimal? This is a dataset that I have imported through Web Query.

I clicked on the Abc and changed to whole number but it gave ERROR.

[selimovd · Accepted solution]

Hey @learner03 ,

before you change it you have to get rid of the equal sign.

For that select the column, go to Transform --> Replace Values:

Then in the dialog replace the equal sign with nothing:

Afterwards you can change the type to whole number.

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic