topic Loading from two tables in QlikView

Loading from two tables

Tue, 02 Sep 2014 15:46:07 GMT

Good afternoon,

I´ve got two tables (i.e. budget 2014 and budget 2015) with the same columns on an SQL DB and want to (a) concatenate them and (b) create some new fields while loading. So I write:

CONNECT TO GISDB;
Budget:
load *,
GIS_DeliveryOrder_No & ' ' & GIS_DeliveryOrder_Name as GIS_DeliveryOrder,
'20' & Left (RecID,2) as Year;
SQL select * from GISdb.BUDGET."BUDGET_2014_vw";
concatenate SQL select * from GISdb.BUDGET."BUDGET_2015_vw";

This works but results in an initial GIS_DeliveryOrder and Year for records from the 2015 table. What would be an appropriate syntax?

Many thanks in advance,

Leonardo

Re: Loading from two tables

jagan — Tue, 02 Sep 2014 15:48:14 GMT

Hi,

Try like this

CONNECT TO GISDB;
Budget:
load *,
GIS_DeliveryOrder_No & ' ' & GIS_DeliveryOrder_Name as GIS_DeliveryOrder,
'20' & Left (RecID,2) as Year;
select * from GISdb.BUDGET."BUDGET_2014_vw";

concatenate (Budget)

load *,
GIS_DeliveryOrder_No & ' ' & GIS_DeliveryOrder_Name as GIS_DeliveryOrder,
'20' & Left (RecID,2) as Year;

select * from GISdb.BUDGET."BUDGET_2015_vw";

Regards,

Jagan.

Re: Loading from two tables

vijay_iitkgp — Tue, 02 Sep 2014 16:03:29 GMT

You can also use following if both table has same schema:

CONNECT TO GISDB;
Budget:
load *,
GIS_DeliveryOrder_No & ' ' & GIS_DeliveryOrder_Name as GIS_DeliveryOrder,
'20' & Left (RecID,2) as Year;
select * from GISdb.BUDGET."BUDGET_2014_vw";

load *,
GIS_DeliveryOrder_No & ' ' & GIS_DeliveryOrder_Name as GIS_DeliveryOrder,
'20' & Left (RecID,2) as Year;

select * from GISdb.BUDGET."BUDGET_2015_vw";

Re: Loading from two tables

Wed, 03 Sep 2014 07:59:45 GMT

That works, thanks!

Re: Loading from two tables

jagan — Wed, 03 Sep 2014 08:44:21 GMT

Please close this thread by giving correct answer.

Regards,

jagan.