What should be the data model for circular reference table

[#1]

Hi,

  I have 3 tables... I am getting circular reference message so I changed the column names ( I could use QUALIFY as well).

But now I am not able to create the graphs as I wanted. So what should be my datamodel design where in I should get the appropriate results

and should not get any results if the data selected is irrelevant.

I have attached the sample xls and qvw file.

Thanks

Lax

[#2]

Hi Laxmikant,

Dont alias the field names and just concatenate the three tables. You will not get any issues in the front end.

Regards,

Kiran Rokkam.

[#3]

Hi,

Load a Mastertable - the one with both Branch and PolNo first. Then Left Join or Concatenate LOAD the other two tables...

Best regards

Torbjörn Ungvall (@Ungvall)

Senior Business Discovery Manager @ Advectas AB

[#4]

Hi,

  I concatenated the tables, now I get data for one graph. But for another I don't i.e the PAMOUNT is shown but no branch is shown for it. Similarly if I select PHGender or REGION I don't see the PAMOUNT. I should be able to see the PAMOUNT for this selection.

I am attaching the modified docs.

Thanks,

Lax

[#5 · Accepted solution]

Hi,

Same result if you use LEFT Join (Mastertable) instead?

Best regards

Torbjörn Ungavll (@Ungvall)

Senior Business Discovery Manager @ Advectas AB

[#6]

Updated the file. Does this work?

Regards,

Kiran.

[#7]

Hi, Thanks for the multiple solution, one with explicit key  and other without it...both of them work.

Regards,

Lax