Circular Joins (3 Tables joining each other on the same key)

[sudhakar_budde]

Hi,

I have 3 tables joining on the same key. Is this normal?

I am thinking this is a circular join.How can I resolve this? Please see attached table viewer screenshot.

Thanks in advance for your suggestions.

SB

[datanibbler · Accepted solution]

Hi sudhakar,

no - at least, what is seen on that screenshot, that is not a circular JOIN, that is quite ok - QlikView would issue a warning if you had a circular reference - you run that risk only if you have several different keys that join A to B, B to C and C to A, not if all three tables share the same key.

Best regards,

DataNibbler

[Anonymous]

Sudhakar,

Joining with singleKey for multiple table is not circular reference. Its ok with QV.

See below link by HIC. you will be clear on circular reference.

Circular References

Thanks

BKC

[sasiparupudi1]

It is not a circular reference issue and your join looks fine

[sudhakar_budde]

Hi Sasidhar,

Thanks for your reply.

[sudhakar_budde]

Hi Balkumar,

Thanks for your reply.

Regards

SB

[sudhakar_budde]

Hi,

Thanks for your reply.

SB