Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Need help here folks. I have followed instructions exactly and getting failures. Here is script:
Rollup:
LOAD *
;
SELECT
[TestVar],
[Rolls Up To]
from X
;
TEST:
CrossTable(TestVar, Value, 1)
LOAD *
;
SELECT
[y1],
[y2]
;
Final:
LOAD *
, ApplyMap('Rollup', TestVar)
RESIDENT TEST
;
DROP TEST
It looks like it finishes and then it goes back to the home screen and it says it failed to load. What a nightmare.
Some fixing and cleaning is needed:
Rollup:
MAPPING SELECT DISTINCT
[TestVar] as A,
[Rolls Up To] as B
from X
;
TEST:
CrossTable(TestVar, Value, 1)
LOAD
[y1],
[y2]
;
SELECT
[y1],
[y2]
;
Final:
LOAD *
, ApplyMap('Rollup', TestVar) as NewField
;
DROP TABLE TEST;
Hope i didn't miss anything essential...
Regards,
Michael