Relate Tables (Multiple Tables)

jmonroe918 — Wed, 22 Mar 2017 03:30:22 GMT

I need help getting a column of data from one table into another table, through third table.

The end result is I need the data from 'Site' in the Audits table to be listed in the Audit Findings table.

Here's the background:

Audits are created with an 'AU-" number. Some Audits have Audit Findings with an "AUF-" number. The "AUF-" is connected to the "AU-" in the relationship tables.
The Audit Finding links to the Audit Finding Relationship table with the ID. AUF-00002 lists AU-00002 as the 'Finding Rel Obj Name'. AU-00002 lists Vista as the 'Site'.
I need to list Vista as the 'Site' in AUF-00002 (So I can then create a chart showing Audit Findings Per Site")

I've tried using Mapping, Left Joins, etc but can't seem to get it.

Any help is appreciated.

The QVW is attached.

Thanks

Jeff

topic Relate Tables (Multiple Tables) in QlikView