Thank you Steve for your suggestion. However, here the issue was slightly different. The metadata was not there in the transaction table. Therefore, I thought of an alternative of having a master table with all combinations of metadata. You might want to have a look at the issue from the start and may come up with a better solution. Your inputs are always great ones to have .
