Concatenate

[#1]

Hi All

I have a table called [Mobile Data] and want to load a script then concaternate it to [Mobile Data].

I'm getting an error when I try to concaternate my statement to the existing table. Please Help

Concatenate ([Mobile Data])
Printing:

SQL SELECT Area,
    "Colour Cost",
    "Colour Prints",
    "Colour Total",
    FY,
    "Mono Cost",
    "Mono Prints",
    "Mono Total",
    Month as "Print Month",
    Office,
    "Total Cost",
    "Total Pages"
FROM GTSBilling.HLD.PRINTINGNAT;

Left join ("Printing")
LOAD PHYSICALOFFICE as Office,
     REGION as Region,
     COUNTRY as Country
FROM

(biff, embedded labels, table is Offices$);

Left join ("Printing")
LOAD distinct
[Dept Code] as DEPTID,
Department,
Level5 as "Department Common Name",
Division,
[LOS Detail] as LoS
FROM QVD\DEPARTMENTS.QVD (qvd);

[Anonymous · Accepted solution]

Hi try this

Printing:

SQL SELECT Area,
    "Colour Cost",
    "Colour Prints",
    "Colour Total",
    FY,
    "Mono Cost",
    "Mono Prints",
    "Mono Total",
    Month as "Print Month",
    Office,
    "Total Cost",
    "Total Pages"
FROM GTSBilling.HLD.PRINTINGNAT;

Left join ("Printing")
LOAD PHYSICALOFFICE as Office,
     REGION as Region,
     COUNTRY as Country
FROM

(biff, embedded labels, table is Offices$);

Left join ("Printing")
LOAD distinct
[Dept Code] as DEPTID,
Department,
Level5 as "Department Common Name",
Division,
[LOS Detail] as LoS
FROM QVD\DEPARTMENTS.QVD (qvd);

Concatenate ([Mobile Data])

load * resident Printing;

drope table Printing;

Regards

Harsha

[#3]

Thanks a lot. This works perfectly

[Anonymous]

you are welcome...