Specify the table name

[#1]

Morning all,

Can I specify the table name in the import script? I'm thinking particularly when I am concatenating from two sources eg:

select * from SourceA
concatenate
select * from SourceB

and I want to see the table as CombinedTable.

Any ideas?

Thanks,

Tony

[prieper · Accepted solution]

The concatenated file will inherit the name of the first file, thus your script may read:

CombinedFile:
select * from SourceA;
concatenate (CombinedFile) select * from SourceB;

It is not necessary in this example to specify, to which file the "B" should be added, but it makes script a bit clearer and prevents error, if you shuffle the code around.

HTH
Peter

[#3]

Cracking! Thanks v much Peter,

Tony