Parameterize a Sample analysis as follows:
- Available Tables — TWM_CUSTOMER
-
Selected Columns and Aliases
- 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
- Output Type — Multiple Views
- Table Name — Twm_Cust_Sample
-
View Names (3)
- Twm_Cust_Sample1_view
- Twm_Cust_Sample2_view
- Twm_Cust_Sample3_view
For this example, the Sample analysis generated a "behind-the-scenes" table with 448 rows and 3 views with sizes 75, 149 and 224. Each view looks just like the input table, and the "behind the scenes" table has an added column "xSampleId" that is used by each view. Again, the SQL is not shown, and the specific rows returned will vary randomly. The data page will have a Load button which must be clicked to view the three results.