Need help with Applymap and Crosstable

[#1]

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. 

[Anonymous]

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