Parameterize a Merge analysis as follows:
-
Selected Columns
- twm_customer_dqa.cust_id
- twm_customer_dqa.income
Rename income to inc by clicking on the selected column income and changing the name to inc
- twm_customer_dqa.age
- twm_customer.cust_id
- twm_customer.income
- twm_customer.age
- Merge Style — Minus
- Retain Duplicate Rows — No
- Where Clause (both tables) — cust_id < 1362490
For this example, the Merge analysis generates the following results data:
cust_id | income | age |
---|---|---|
1360000 | 29592 | 29 |
1360001 | 27612 | 39 |
1360002 | 57612 | 49 |
1362480 | 33 |