jlafee

Discussions

Is there a way to convert a numerical string to a number value in Beast Mode?
We have a very large dataset (10+MM rows currently) and for some reason our fiscal week is located in a column formated as YYYYMMWW. I can use a RIGHT(`FiscalYearWeek`,2) to get the value for the week, but it's a string, not a number. Is there a way to convert this to a number so I can then compare it via greater or lesser…
Using Data Joins - Limits to Join Data?
Hi Everyone, I have a data set of about 400K rows of sales data. It includes our item code, but no other details. I'm trying to match it to our item master, which has about 2K rows to fill in the blanks. I know there is a limitation to the left dataset in a join, I believe it's 10K rows, so I'm using the item list on the…

Is there a way to convert a numerical string to a number value in Beast Mode?
We have a very large dataset (10+MM rows currently) and for some reason our fiscal week is located in a column formated as YYYYMMWW. I can use a RIGHT(`FiscalYearWeek`,2) to get the value for the week, but it's a string, not a number. Is there a way to convert this to a number so I can then compare it via greater or lesser…
Using Data Joins - Limits to Join Data?
Hi Everyone, I have a data set of about 400K rows of sales data. It includes our item code, but no other details. I'm trying to match it to our item master, which has about 2K rows to fill in the blanks. I know there is a limitation to the left dataset in a join, I believe it's 10K rows, so I'm using the item list on the…