Is it possible to load additional records from another file to a crosstable

[#1]

I have created a crosstable in my script that uses a specific file and I want to add some additional data to the crosstable from another file.  Is that possible to do & if so, how????

Here is how I've created the crosstable:

BenchMarkTable:

CrossTable(Measure,Value,3)

LOAD

    ITEM,

    FYEAR,

    FPERIOD,

    sum(NO_UNITS) as [Shipment Qty],

    sum(SALES_AMNT) as [Gross Sales],

    sum(REV_ACES_DEF) as [ACES/CARE Deferred Billings],

    sum(REV_ACES_REC) as [ACES/CARE Revenue Recognition],

    sum(REV_REBATES) as [Rebates],

    sum(REV_ALLOC) as [Allocation Adjustments],

    sum(REV_TOTAL) as [Net Revenue],

    sum(BOM_COST) as [BOM Cost @ Std - no surcharge],

    sum(OTH_COGS) as [Other COGS @ Std],

    sum(MAN_FGS) as [Manual FGS],

    sum(INS_MAT_COST) as [Material Cost for NI],

    sum(SERV_COGS_DIR) as [Service COGS (Direct)],

    sum(SERV_COGS_ALLOC) as [Service COGS (Allocated)],

    sum(SERV_OPEX) as [ACES OPEX],

    sum(TOT_FGS) + sum(SERV_OPEX) as [Total FGS (and Services COGS)],

    sum(GROSS_PROFIT_AT_FGS) + sum(SERV_OPEX) as [Gross Profit @ FGS],

    sum(GROSS_PROFIT_AT_FGS)/ sum(REV_TOTAL) as [Gross Margin @ FGS]

Resident gross_profit

GROUP BY ITEM, FYEAR, FPERIOD;

I have another file that would contain override values for each measure and I was wondering if I could just add those to the table.

so the value would be different but the measure would be the same.

For instance I would have a override value for 'Shipment Qty', override value for 'Gross Sales', etc.

[Gysbert_Wassenaar]

It's possible. It depends on the data structure of the second file what you need to do. If the structure is the same as the first one you can create a table that contains the concatentated data from both files and then use the crosstable function with a resident load. Otherwise you'll have to use the crosstable function in two separate loads and then concatenate the two result tables into one final table.