Loading from two tables

[#1]

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

[jagan]

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.

[vijay_iitkgp]

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

[#4]

That works, thanks!

[jagan]

Please close this thread by giving correct answer.

Regards,

jagan.