This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.

Learn more
I AGREE
Reject
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.
community Data Science Portal Alteryx.com
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Free Trial

Alteryx Designer Discussions

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

Converting strings to numbers

Mhnd
7 - Meteor
‎12-29-2021 04:56 AM

Hi everyone,

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

Thanks

convert field to int then sum those numbers in this exact field.yxmd
Labels:
Reply
0 Likes

Accepted SolutionSolved! Go to Solution.

6 REPLIES 6
r_manju02
8 - Asteroid
‎12-29-2021 05:56 AM

Hi,

 

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

convert field to int then sum those numbers in this exact field.yxmd
Reply
Qiu
19 - Altair
19 - Altair
‎12-29-2021 05:56 AM

@Mhnd 

Can you give us a sample of your expected output?

Reply
binuacs
16 - Nebula
‎12-29-2021 06:50 AM

@Mhnd are you looking for something like below?

 

binuacs_0-1640789394073.png

 

convert field to int then sum those numbers in this exact field.yxmd
Reply
Mhnd
7 - Meteor
‎12-30-2021 07:08 AM

Amazing:)

Thanks

Reply
0 Likes
Mhnd
7 - Meteor
‎12-30-2021 07:10 AM

That was what I'm looking for 🙂

Thanks

Reply
0 Likes
Mhnd
7 - Meteor
‎01-02-2022 11:28 PM

What if the data be like this?

convert field to int then sum those numbers in this exact field.yxmd
Reply
0 Likes
Labels