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.
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?