i am working on a scheduled script that is using N/query to get data from transactions to build a csv file. I first created the dataset in Analytics so I can get the correct sql statements and it works fine except for this:

BUILTIN_RESULT.TYPE_STRING("TRANSACTION"."TYPE") AS "TYPE" /*{type#RAW}*/

the column is showing on the csv but the rows are blank even though it is populated the dataset in Analytics. Any ideas why?