I consulted with my friend and found a solution for the above loop issue in which we have created Hospital-Brand-TA link table and all other table are joined through this link table. Attached is the solution qvw.
But now the problem is if I don’t get HospBrandLink table from db I need to generate it manually so that I can create ‘Link’ table. Hospital brand relationship is present in multiple tables like Direct Sales, MAT etc… I need to take all these table into consideration and need to find all possible combination of hospital – brand ids present in db.
Am I thinking in correct direction and Is this solution correct?
Thanks in advance,
LoopQuestion1.qvw 151.2 K