community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE
SOLVED

Convert MSSQL Money Field to Int in Alterys

Highlighted
Meteor

 

The field I am getting from the Data Warehouse is ‘FactPerformance.NetMTDMonthlyADBAmt’ and is a data type ‘Money’ in MSSQL. Alteryx reads it as ‘V_String’ so I convert it to an Int64 after I stream the data out to the select statement in the first stream.  I then summarize and sort the data and the output is spot on.  This process takes almost 30 seconds and it works.

 

I want to speed up the process and do the work in-DB.  I read the data in the second string and convert ‘NetMTDMonthlyADBAmt’ to an INT. I received the error when I tried to summarize the field and browse. The second stream takes a couple seconds.

 

How do I get around this error and speed up my workflow using IN-DB tools?

 

<see the attachment for screen shots>

Bolide

Hey the error you are getting is a database error noting you that your resulting output (the sum of your columns) is too big for the type INT.

 

The int type has a limit and i believe the limit is 4 bytes, or 2,147,483,647...

 

instead of converting it to int convert it to BIGINT.  This should fix your error and your workflow should work :-)

 

Try this first and let me know if speed is still a problem (it honestly shouldn't be)

Labels