Return 0 instead of blank field in BAQ for PartTran

[klincecum (Kevin Lincecum)]

@jtownsend

As to how you’d get a list of dates, I’ve never done that in a BAQ personally. I usually script up a loop in SQL. You could probably set up a UserCode, fill it with dates, and join on that. I wouldn’t burn a whole UD table on it.

I’d have a hard time explaining this on phone but you could hack something together with row_number probably.

relevant:

String_split in BAQ

To add on to @jdtrent’s comment… Make a sub that returns the top 100 rows(or whatever the max number of fields you expect) of a table that has at least that many rows (parttran always has lots of rows). It only needs 2 fields: Company (just something to link it to the next subquery) Calc field: Name: RowNum Type integer Expression: ROW_NUMBER() OVER(ORDER BY PartTran.TranNum) Now make a subquery with the table containing the field to split , and the above subquery. The Calc field wil…