Parameterize a Join Analysis as follows:
-
Selected Columns
- TWM_CUSTOMER.cust_id
- TWM_CHECKING_ACCT.ending_balance (Rename to Chk_Bal)
- TWM_CREDIT_ACCT.ending_balance (Rename to Crd_Bal)
- TWM_SAVINGS_ACCT.ending_balance (Rename to Sav_Bal)
For this example, the Join Analysis generated the following results. Note that the SQL is not shown for brevity.
Only the first 10 rows shown.
cust_id | Chk_Bal | Crd_Bal | Sav_Bal |
---|---|---|---|
1362759 | 4.62 | 835.19 | 79.52 |
1363088 | 769.47 | 739.86 | 1426.1 |
1362587 | 292 | 859.44 | 1596.17 |
1362952 | 473.45 | 782.77 | 232.76 |
1362771 | 141.86 | 1200 | 2361.62 |
1363316 | 947.22 | 1000 | 629.06 |
1363342 | 14.45 | 1600 | 57.96 |
1362700 | 4494.03 | 107.4 | 315.88 |
1363448 | 1961.87 | 1400 | 1763.31 |
1362936 | 109.31 | 244.47 | 792.11 |
... | ... | ... | ... |
... | ... | ... | ... |
... | ... | ... | ... |