Hi Bert,
Your example is Perfect.
You are using "dataA" and "matchedA".But thing is that the "matchedA" field is defined by me.. Acually it's a label and I have written the expression for it.
And it is not possible to define one by one which is matched or unmatched as there are billions of records.
That's the problem why I can not able to do it.
Any other solution is there.
Please have a look on that .bmp file which I have sent you.
There you can able to see two straighboxes are created i-account_aspen vs account_med ii- contact_aspen vs contact_med.
The first table contents are :
orgcode, aspen_orgname, med_orgname, aspen_orgstatusname, med_orgstatusname, aspen_orgtypename,med_orgtypename,postal_street, med_postalstreet, shipping_street, med_shippingstreet, Matching_status.
Matching_status field is added by me actually it's a label and the expression is "
if(med_orgname=aspen_orgname and med_orgstatusname=aspen_orgstatusname and med_orgtypename=aspen_orgtypename
and postal_street=med_postalstreet and shipping_street=med_shippingstreet,'matched','unmatched')".
The fields in 2nd table :
personcode, aspen_initial, med_initial, aspen_firstname, med_firstname, and so on....
In second table service_status is a label and the expression is
if(aspen_person_service=med_person_service, 'Included', 'Excluded')
.
Now I have to add flags which will filter only matched/unmatched/excluded/included.
Note: Aspen and medpages are two different datasources from which data are loading.
May be this explanation will make you clear what I am trying to convey .
