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
- .1
- .2
- .3
For this example, the Sample analysis generated the following results. Again, the SQL is not shown, and the specific rows returned will vary randomly.
Only the first 10 rows shown.
cust_id | income | age | years_with_bank | nbr_children | gender | marital_status | xsampleid |
---|---|---|---|---|---|---|---|
1362691 | 26150 | 46 | 5 | 1 | M | 2 | 1 |
1362548 | 44554 | 59 | 9 | 2 | F | 4 | 1 |
1363160 | 18548 | 38 | 8 | 0 | F | 1 | 3 |
1363017 | 0 | 16 | 1 | 0 | M | 1 | 3 |
1362487 | 6605 | 71 | 1 | 0 | M | 2 | 2 |
1363486 | 39942 | 41 | 1 | 5 | F | 4 | 2 |
1363200 | 21015 | 18 | 3 | 0 | M | 1 | 3 |
1363282 | 25829 | 29 | 8 | 0 | F | 1 | 3 |
1362527 | 17622 | 44 | 1 | 0 | M | 2 | 3 |
1362609 | 1929 | 79 | 8 | 0 | F | 2 | 3 |
... | ... | ... | ... | ... | ... | ... | ... |
... | ... | ... | ... | ... | ... | ... | ... |
... | ... | ... | ... | ... | ... | ... | ... |