topic Re: Concatenate in QlikView

Concatenate

Tue, 18 Nov 2014 11:02:06 GMT

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);

Re: Concatenate

Anonymous — Tue, 18 Nov 2014 11:32:41 GMT

Hi try this

Printing:

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

Re: Concatenate

Tue, 18 Nov 2014 11:40:06 GMT

Thanks a lot. This works perfectly

Re: Concatenate

Anonymous — Tue, 18 Nov 2014 11:41:30 GMT

you are welcome...