2022.1.1.30569 Patch Release Update

The 2022.1.1.30569 Patch/Minor release has been removed from the Download Portal due to a missing signature in some of the included files. This causes the files to not be recognized as valid files provided by Alteryx and might trigger warning messages by some 3rd party programs. If you installed the 2022.1.1.30569 release, we recommend that you reinstall the patch.

Alteryx Designer Discussions

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

Converting strings to numbers

Mhnd
7 - Meteor

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
19 - Altair
19 - Altair

@Mhnd 

Can you give us a sample of your expected output?

binuacs
16 - Nebula

@Mhnd are you looking for something like below?

 

binuacs_0-1640789394073.png

 

Mhnd
7 - Meteor

Amazing:)

Thanks

Mhnd
7 - Meteor

That was what I'm looking for 🙂

Thanks

Mhnd
7 - Meteor

What if the data be like this?

Labels