Append records with different field names

[#1]

Hi Experts,

I want to append records into one table from two different tables, but on my two tables the number of fields and field order arrangement  is same for both. But here field names are different

Note : I cannot change the field names on Table2

Illustration

Table1

FieldName1	FieldName2	FieldName3
aaa1	aaa2	aaa3
bbb1	bbb2	bbb3

Table2 (with different names - but table structure is same as Table1)

@1	@2	@3
ccc1	ccc2	ccc3
ddd1	ddd2	ddd3

Result

FieldName1	FieldName2	FieldName3
aaa1	aaa2	aaa3
bbb1	bbb2	bbb3
ccc1	ccc2	ccc3
ddd1	ddd2	ddd3

[ogster1974 · Accepted solution]

Result:

Load

'Table1' AS Source,

FieldName1,

FieldName2,

FieldName3

from

Table1;

Concatenate

Load

'Table2' AS Source,

@1 as FieldName1,

@2 as FieldName2,

@3 as FieldName3

from

Table2;

Should do it.  Identifying the source in a separate column will help to refer back to your source files and for testing purposes.

Regards

Andy

[reddy-s]

Hi Debabrata,

As Andy mentioned concatenate should solve your issue.

[#4]

Thanks a lot Andy.