topic Re: Concatenating Tables in QlikView

Concatenating Tables

Fri, 15 Jun 2012 20:47:51 GMT

I have 3 tables with the same field names. Is there anyway I can concatenate the tables into one table with the same field names?

VendorRAN:

load

(APHVCH) as LINK_KEYV1,

APHVCH,

Concat(if(APHNAM<>'SIOUX FALLS TAX',if(APHNAM<>'BALTIC TAX',if(APHNAM<>'EARTH CITY TAX',if(APHNAM<>'HURON TAX',if(APHNAM<>'TEXAS TAX - AUSTIN',APHNAM))))),'; ') as C

FROM

$(vQVDPath)AppVendorRAN.qvd (qvd);

VendorAER:

load

(APHVCH) as LINK_KEYV1,

APHVCH,

Concat(if(APHNAM<>'SIOUX FALLS TAX',if(APHNAM<>'BALTIC TAX',if(APHNAM<>'EARTH CITY TAX',if(APHNAM<>'HURON TAX',if(APHNAM<>'TEXAS TAX - AUSTIN',APHNAM))))),'; ') as C

FROM

$(vQVDPath)AppVendorAER.qvd (qvd);

VendorCAN:

load

(APHVCH) as LINK_KEYV1,

APHVCH,

Concat(if(APHNAM<>'SIOUX FALLS TAX',if(APHNAM<>'BALTIC TAX',if(APHNAM<>'EARTH CITY TAX',if(APHNAM<>'HURON TAX',if(APHNAM<>'TEXAS TAX - AUSTIN',APHNAM))))),'; ') as C

FROM

$(vQVDPath)AppVendorCAN.qvd (qvd);

Re: Concatenating Tables

rwunderlich — Fri, 15 Jun 2012 20:54:17 GMT

Concatenation is the default when Field Names are the same. In your example, you will have all rows in ones table -- VendorRAN. You don't have to do anything different. Note that the VendorAER and VendorCAN tables will not be created.

-Rob

Re: Concatenating Tables

Mon, 18 Jun 2012 15:07:09 GMT

Is there any way to concatenate differently named fields in different tables in my script?

Re: Concatenating Tables

rwunderlich — Mon, 18 Jun 2012 15:30:15 GMT

You can force or suppress concatenation by using the CONCATENATE / NOCONCATENATE prefix on the Load statement.

-Rob