topic modeling in QlikView

modeling

Wed, 20 Feb 2013 12:16:29 GMT

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

Re: modeling

Wed, 20 Feb 2013 12:27:34 GMT

I didnt get your point please upload the sample application

Re: modeling

Wed, 20 Feb 2013 12:33:18 GMT

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

Re: modeling

Wed, 20 Feb 2013 12:50:34 GMT

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;

Re: modeling

Thu, 21 Feb 2013 05:34:28 GMT

Hi Vishwa,

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