Free Trial

Alteryx Designer Desktop Discussions

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

Converting strings to numbers

Mhnd
8 - Asteroid

Hi everyone,

how can i convert those fields to integers then sum those numbers in this exact field?

Thanks

6 REPLIES 6
r_manju02
8 - Asteroid

Hi,

 

You need to parse, before calculating the total (refer attached workflow)

Qiu
21 - Polaris
21 - Polaris

@Mhnd 

Can you give us a sample of your expected output?

binuacs
21 - Polaris

@Mhnd are you looking for something like below?

 

binuacs_0-1640789394073.png

 

Mhnd
8 - Asteroid

Amazing:)

Thanks

Mhnd
8 - Asteroid

That was what I'm looking for 🙂

Thanks

Mhnd
8 - Asteroid

What if the data be like this?

Labels
Top Solution Authors