Without knowing exactly what you are doing, I can suggest in your magic ETL under the utility option to use the formula box. This basically lets you program what ever you need in SQL.

Hi guys, I found a work around that makes it possible to have at least 12 columns from a table show up in a scheduled report. First i created a new tab just for the table that needs to go out with more than 3 columns, then i scheduled the 'tab' with only one card on it to go out as a scheduled report. I then get all the…