modeling

[#1]

HI,

  i have two tables name 'A ' and 'B'   with one key field.now i want one more field from table B in to table A.

how can i acheive this 

[#2]

Hi

I didnt get your point please upload the sample application

[#3]

HI nirmal,

   suppose i have two tables

Table!:

field1,

field2,

field3,

field4

table2:

key1,key2,field1,key3

here my unique key is field1. now i want the field key3 from table2 in to table1

[#4]

hi

table1:

LOAD * INLINE [

    F1, F2, F3, F4

];

table2:

LOAD * INLINE [

    k1, k2, F1, k3

];

join:

join(table1)

LOAD k3 Resident table2;

drop Field k3 From table2;

*****************************************************************************************

or also write it

table1:

LOAD * INLINE [

    F1, F2, F3, F4

];

table2:

LOAD * INLINE [

    k1, k2, F1, k3

];

join:

join(table1)

LOAD k3 Resident table2;

[#5]

Hi Vishwa,

  I tried your logic.but i dnt work when iam applying ''join'' the application is not reloading. Please help me