Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Data Convertion Number to String field

Seba
7 - Meteor

Hi All, I need to convert, only last row and only the 4 filed marked below, from Number to String in order to convert those percentages like so "27 %", instead of "0.267067"

Any ideas?

 

Percentage.jpg

 

here is the data type for heach column:

 

Data Type.jpg

 

Appreciate any help!

5 REPLIES 5
Raj
15 - Aurora

rows are not converted to different data types.
the data type is for Rows. so, if you need to make that string you need to set the complete column to string.

Seba
7 - Meteor

Hi Raj, I split lines in order to do so, with the intention of union them up after, but I wasnt able to convert it.

 

I've used a filter tool to split last row

LastRow1.jpg

 

then I've used a transpose tool in order to get all values on the same column and then transfor data to string (only for las row)

 

LastRow.jpg

 

Metadata.jpg

Does this helps?

Do you know any way to get this done?

Qiu
21 - Polaris
21 - Polaris

@Seba 
I would do the same as you by seperating the last row from the main stream and do some manipulation as below.

1222-Seba.png

Seba
7 - Meteor

@Qiu Thanks for your answer, it worked! 

Qiu
21 - Polaris
21 - Polaris

glad it helps😁

Labels