Differenciate between tables

[#1]

Hi All,

I have two table like:-

Table A:

name,

ID,

salary

Table 2:

name,

ID,

salary,

test

After reloading the data I am able to see only one table in Table A View, if I am droping Table A then I am not able to see any table.

According to my requirement I need to get the data of Table 2 in my file.Kindly help me out to perform this activity.

Thanks,

D J

[manideep78]

Hi according to you. those two tables are differing by a column test. Hence they wont concatenate  and synthetic keys will be formed. so you can easily drop your first table. if both are having same column name irrespective of their order then they both will concatenate. in this case try below one.

Table A:

Load

name,

ID,

salary

....................

Table 2:

NOCONCATENATE

LOAD

name,

ID,

salary,

test

.............................

Drop table Table A

hope this helps

[swuehl]

Are you concatenating the two tables? How does your script look like in detail?

[#4]

I am taking the resident of table A to join in other table. E.X:-

Table A:

A,

B

Table B:

Load * from Table c;

join

Load ..... resident table A;

Concatinate

Table D;

[#5]

HI I have explained the condition below.

Thanks for your reply but sorry it's not working.

Regards,

D J

[manideep78]

If Table C and Table D contains same fields as Table A then they will automatically concatenate to first table i.e, Table A. Hence If you drop Table A finally no data will exist

[#7]

Table A and Table D have same fields and yes after droping the table A I am not able to see any data. And I need help on this

[manideep78]

Which table data you need?  can you please tell me you requirement in detail? If possible post sample app.