Basically, I have 2 fields in table1 which are: and 3 fields in Table2 which are: What I want is:
Whether the distributor and ProductName both of them at the same time are available in table2 . If they together exist then I should be able to write "1" to somewhere (maybe in a new field in table2), otherwise if they dont exist in table2 I should be able to write "0" to somewhere to able to promote these distributors. Do you have any clear idea about how to do that?
Thank you so much for that prompt helpful reply, very grateful. I works perfect. I just changed slightly the field names in table1 not to have sytnetic relation in tables. Hovewer, I want it make it differanciate when it is "0", the are 2 possiblities, table1key is not there, it doesnt show this . For example: Distributor 12002 and ProductName B is not shown anywhere. What the code give "0" for the one is not in table1 and available in table2 . For instance: 12001 distributor and Name F. The code assign for this "0". I want it to differantiate from the one i explained with assigning for instance -1. Do you know how can i do it? I attached the qlikview.
Thanks alot...
Table1:
LOAD *, DistributorH&'-'&ProductNameH as table1key;
LOAD * INLINE [
DistributorH, ProductNameH
12001, A
12002, B
12003, C
12004, D
12005, E
12002, F
12003, G
];
Table2:
LOAD *,if(exists(table1key,Distributor&'-'&ProductName)='-1',1,0) as VarYok;
