Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Amelia,
Where is the confusion? Can you come up with a bit more details where you are getting stuck?
I used Qualify Table1;
Table2:
Load col1,col2,col3 ......
from table2.qvd
but again it's showing sameerror.
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
To be honest I couldn't able to get as I transformed columns that's the reason I can't use *.
I think we are not on the same page. Can you please post the entire script you are trying with?
can u please post the model table structure?
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.