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.

[tresesco]

Amelia,

Where is the confusion? Can you come up with a bit more details where you are getting stuck?

[#3]

I used Qualify Table1;

Table2:

Load col1,col2,col3 ......

from table2.qvd

but again it's showing sameerror.

[tresesco]

amelia2000 wrote:

I used Qualify Table1;

Table2:

Load col1,col2,col3 ......

from table2.qvd

but again it's showing sameerror.

,

Qualify can't qualify a table. You have to read my earlier post carefully. Use

  Qualify * ;

Load col1,col2,col3 ......

from table2.qvd

[#5]

To be honest I couldn't able to get as I transformed columns that's the reason I can't use *.

[tresesco]

I think we are not on the same page. Can you please post the entire script you are trying with?

[techvarun]

can u please post the model table structure?

[#8]

It's not allowing me to post the script that's the reason earlier I send sample by typing and in INLINE table it's working fine.but the problem is with this.