Alteryx Designer Desktop Discussions

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

Convert to Number in SQL Expression Data Base

ancook
6 - Meteoroid

How would I convert this V_String to a number?Screenshot 2024-05-23 112649..png

3 REPLIES 3
terry10
12 - Quasar

Use the ToNumber function in a formula tool

Raj
15 - Aurora

@ancook 
tonumber([Review_Count])

hope this helps you

apathetichell
19 - Altair

create a new field and use a 

CAST("REVIEW_COUNT", AS int)

 

I'd recommend reviewing your db's documentation for any other specifics on numeric types - or error handling.

note 'review_count' in normal SQL is a value whereas "review_count" is a field.

Labels