Convert string to number

Question

Hello team.,

I have some numbers with percentage symbol in string format which is to be converted in number format for calculations.In the output excel file I need to right click on that column everytime to convert into number which I dont have to do.

Thanks in advance.

Luke_C · Answer

@Polite123

Like others have said this isn't fully possible in alteryx, but you should look into the "keep formatting" option for excel outputs. If you output to a range in a template file and have this column formatted as a percentage it should work.

StockMarket · Answer

How about creating a DUPLICATE COLUMN first.

That way you can keep one value in Number Format and another value would have the % symbol as well.

Emil_Kos · Answer

Hi @Polite123,

Unfortunately, it isn't possible. In Alteryx number must be a number. It will not contain a percentage sign.

For this, there is no workaround.