Sampling
Create a table with data sampled from another table.
Sampling allows you to pick data from a source table to fill a target table. The sampling can be random or in a periodic basis.
Sampling is done row-wise. That means, the sampled data will pick the whole line of the source table and copy into a line of the target table.
Sampling Method
Random: Picks exactly Sample Size lines of the source table in a random way.
Sample size: Number of lines sampled from the source table.
Periodic: Picks lines in a pace defined by Period.
Period: the number of lines to skip periodically when sampling.
The following data will be used as example of source data table for sampling:
|
A |
B |
C |
|
|
1 |
11 |
21 |
31 |
|
2 |
12 |
22 |
32 |
|
3 |
13 |
23 |
33 |
|
4 |
14 |
24 |
34 |
|
5 |
15 |
25 |
35 |
|
6 |
16 |
26 |
36 |
|
7 |
17 |
27 |
37 |
|
8 |
18 |
28 |
38 |
|
9 |
19 |
29 |
39 |
Sampling with a period of 2 will result in the following table:
|
12 |
22 |
32 |
|
14 |
24 |
34 |
|
16 |
26 |
36 |
|
18 |
28 |
38 |