Hello
I have a database that holds a lot of tables with defined relationship..
I have connected to the database via OLEDB. #connection successful
roharoha bill.markham theresaa
on the frontend, I have created the table to visual the data.
My challenge is I can link the data from different tables
here are sample tables as they are on the
Company Table
| vOMLId | dAward Date | dExpiration Date
| iOperator Id | vContact TypeId | Status |
|---|
| Company A | 04/04/1980 | 03/04/2000 | 1 | P | 1 |
| Company B | 02/03/1990 | 01/03/2010 | 3 | T | 1 |
| Company C | 03/04/1990 | 02/04/2010 | 2 | P | 2 |
| Company Z | DD/MM/YYYY | DD/MM/YYYY | 3 | P | 1 |
Operator Table
| iOperator Id | Description |
|---|
| 1 | Sony |
| 2 | Samsung |
| 3 | Nokia |
Contract Table
| Contract Type | Description |
|---|
| P | Permanent |
| T | Temporary |
Status Table
| Contract Type | Description |
|---|
| 1 | Producing |
| 2 | Non-Producing |
My Proposed Table on Qlik front end
| vOMLId | dAward Date | dExpiration Date
| iOperator Id | vContact TypeId | Status |
|---|
| Company A | 04/04/1980 | 03/04/2000 | Sony | Permanent | Producing |
| Company B | 02/03/1990 | 01/03/2010 | Nokia | Temporary | Producing |
| Company C | 03/04/1990 | 02/04/2010 | Samsung | Permanent | Non-Producing |
See attached for snapshots
