Parameterize a Sample analysis as follows:
- Available Tables — TWM_CUSTOMER
-
Selected Columns
- TWM_CUSTOMER.cust_id
- TWM_CUSTOMER.income
- TWM_CUSTOMER.age
- TWM_CUSTOMER.years_with_bank
- TWM_CUSTOMER.nbr_children
- TWM_CUSTOMER.gender
- TWM_CUSTOMER.marital_status
- Size or Fraction — 10
For this example, the Sample analysis generated the following results. Note that the SQL is not shown for brevity, and that the specific rows returned will vary randomly.
cust_id | income | age | years_with_bank | nbr_children | gender | marital_status |
---|---|---|---|---|---|---|
1362691 | 26150 | 46 | 5 | 1 | M | 2 |
1362548 | 44554 | 59 | 9 | 2 | F | 4 |
1362811 | 8011 | 82 | 2 | 0 | F | 2 |
1363402 | 24368 | 63 | 3 | 0 | F | 1 |
1363011 | 90248 | 55 | 5 | 0 | M | 4 |
1362826 | 0 | 15 | 0 | 0 | F | 1 |
1363018 | 46884 | 36 | 4 | 2 | M | 2 |
1362793 | 29120 | 36 | 6 | 2 | M | 3 |
1363410 | 28518 | 31 | 1 | 2 | M | 3 |
1362676 | 7230 | 62 | 2 | 0 | M | 2 |