Concatenate

[#1]

Hi,

I want to concatenate 3 tables with same column names and I have a date column also.Now I want to use one calendar for 3tables.But the problem is I should use resindent load in that calendar code and I have 3 date columns in 3 different tables.How can solve this problem?

[chrismarlow]

If the tables have been concatenated is the date field not in the single resulting table?

Otherwise you need to concatenate the 3 date fields to a single temporary table, then use the calendar code, then drop the temporary table.

[Anonymous]

if you have 3 different date fields and you ant a common date field you must rename the fields

Tmp:

load

DATEFIELD1 as DATEFIELD,

*

resident TABLE1;

concatenate load

DATEFIELD2 as DATEFIELD,

*

resident TABLE2

That what you want?

[#4]

Hi,

if you have concatenated the tables then your date field would also have been concatenated????

otherwise you can simply perform resident load on all the 3 particular date fields and then concatenate them...

Hope it solve your problem.

Regards