How to get both tables columns

[#1]

Hi,

I have two tables in different databases but the column names are same when I am trying to reload it is getting Field names must be Unique how to sort this problem can anyone help me.

[#2]

but I have more than 70 columns in that It's difficult to rename all the columns right?

[jagan]

HI,

Can you attach sample script? It helps in understanding.

Regards,

jagan.

[tresesco]

I think you can use QUALIFY keyword like:

Qualify *;

Load A,B from ....;

Load A,B from  .....;

[#5]

How to use this Qualify am getting error?

[#6]

can you tell me How can i add script as it contains vast data.

[tresesco]

Ex:

qualify *;

unqualify TransID;    // If you want a certain one not to qualify, else remove this

select * from tab1;

select * from tab2;

select * from tab3;

Only TransID will be used for associations between the tables tab1, tab2 and tab3.

[#8]

I am trying to use as below it's not working

Qualify Table1;

Table2:

load colu1,

colu2,

etc

from T_tab.qvd

[tresesco]

Don't use table name for qualification. use qualify *; the tables names would be prefixed with the field names automatically.

Qualify *;

load colu1,

colu2

from T_tab.qvd

will generate like T_tab.colu1, T_tab.colu2 fields.

[#10]

How to get this?