illegal combination of prefixes

[Anonymous]

Hi,

I have extracted budget data from excel using cross table and i would want to append to the fact table.

Budget:

concatenate

CrossTable(Month, Budget )

load a

       b

from

[alexandros17]

You have to load it first and then concatenate (because it is a crossatble)

[Anonymous]

Hi,

Precsely what i did, I load it initially and created a loop and now appended it.Perhaps you should please write the syntax.

[alexandros17]

if your crosstable is for example "TableA" and previous tables are "TablesX"

you have to

Finaltable:

noconcatenate

load

     *

resident TablesX;

concatenate

load * resident TableA;

drop tables TableA, TablesX;