Case Generation

Case Gen returns all possible combinations to the given input ranges of data. It produces the cross-product of rows. The number of columns in the result is the sum of the number of columns in each range. The number of rows in the result is the product of the number of rows in each argument.

Each row in the result is produced by taking one row from each of the arguments and placing these rows from left to right. {.content-description}

Sample Data

We will consider a sample sheet containing some days, months and years. Our aim is to find all the dates derived from its combination.

Step 1

Click on the More command under SheetKraft tab.

Step 2

Click on the Case Gen on the drop-down list of More.

Step 3

A window will appear (Generate Cases), click on the marked tab to select data for Range 1.

Step 4

Select the data range manually. If the selected data contain headers then click [ ] My data has headers otherwise no need.

Step 5

In interpret selection, you will have two options. After interpret selection, click on OK.

Step 6

A window will appear (Generate Cases), click on the marked tab to select data for Range 2.

Step 7

Select the data range manually. If the selected data contain headers then click [ ] My data has headers otherwise no need.

Step 8

After interpret selection, click on OK.

Step 9

For Range 3, we need to add one more range by clicking on + marked tab.

Step 10

A window will appear (Generate Cases), click on the marked tab to select data for Range 2.

Step 11

Select the data range manually. If the selected data contain headers then click [ ] My data has headers otherwise no need.

Step 12

After interpret selection, click on OK.

Step 13

A window will appear (Generate Cases), in the window you can see the total number of cases generated. Click on Next.

Step 14

Select a blank range for the final result display. You can either show the result in any of the existing worksheets (and select any blank range) or choose a new worksheet. In this illustration, we have chosen the Existing worksheet [Sheet1!$F$2:$H$21].

Final Result Display

Now we have the complete data in range [Sheet1!$F$2:$H$21].

Final Data

Final data containing total 20 combinations (2[Days]x5[Months]x2[Years]).