How do I group by date in one stage and not by date in next stage of script
Hi,
I used an array of sum(if statements and group by to get alot of columnar data transformed where generic loads and object formulas couldn't work.
Now I have all of the fields I want, but the next stage of my task calls for me to compare TestA values in year one to TestA values in year two and the objects can't handle the quantity of data and/or are constrained by the group by date/year settings.
I want to use/load the fields I have created so far, but I want the next tables to only be grouped by userid and source, and not by testdate or year.
How do I create that boundary in my script, where the first half creates fields and is grouped one way, while the second half draws on those fields but is grouped a different way?
