Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have 2 tables
have created a mergekey between 2 tables but still data is not matching
?
what would be the reason ?
Hi,
Try to check whether your composite key is unique or not by putting expression in list box like below,
count(distinct Key) & for same count(Key)
Both count for Key need to be same or close with each other for unique records.
post your sample data by how it is not matching if your previous thread data is same & for this purpose only you want to see row wise colour is it ?
I am not sure what you mean with a mergekey. I hope the below can guide you int he right direction.
Commonly you associate two table by having a common field in both table. This field must be named exactly same in both tables, i.e. the names are associated in a case sensitive manner.
If you have more than one common field between the table you get a synthetic key, which can lead to unexpected results. This must be avoided for best possible reliability in your application.
The values in the key fields are also matched in a case sensitive manner. If you have the value ABC in one table and Abc in the other table, these will not be linked.
composit key i have created
have same statement in another table also
still in my data mismatch is there
Unfortunately that does not help me understand your issue. Please attach a sample QVW file so that your issue can be analysed.
can you post sample data/ a sample application?
regards
Marco
Hi,
Try to check whether your composite key is unique or not by putting expression in list box like below,
count(distinct Key) & for same count(Key)
Both count for Key need to be same or close with each other for unique records.
post your sample data by how it is not matching if your previous thread data is same & for this purpose only you want to see row wise colour is it ?
data doesn't match in your 2 tables
error in script