User Input in Fill Cell Jobs
You can update data across cells in a data coverage task to create data where needed. User input might be needed in some situations where data is missing.
You can compare combinations of data from a single table or combinations of data from different tables. The X and Y axis can therefore represent columns from the same table or from different tables.
When you compare columns from the same table, a fill operation from one cell to another cell moves data that exists in a single table. The data is available to move and the fill operation runs without the need for user input.
When you compare columns from different tables, some records in intermediate tables might not exist in the database. These records might be required for the combination corresponding to the target cell.
When there is no data available to fill a cell, you must enter the data values manually. The job pauses when user input is required. If the data coverage task is open, a dialog box appears with fields to enter data values.
Enter data values that match the column data type. A move operation fails if the data that you enter does not match the column data type.
User Input Example
You want to analyze the data for employees in an organization. You want to analyze data for the different paygrades across regions. You create a data set that contains information on employee paygrades and organization branch and regions.
Example Data
Consider the following data set tables:
REGION_ID | REGION_NAME |
|---|
1 | East |
2 | West |
3 | North |
4 | South |
BRANCH_ID | BRANCH_NAME | REGION_ID | IFSC | FACILITY |
|---|
102 | Jaipur | 3 | 1545 | Large |
105 | Bangalore | 4 | 6765 | Small |
103 | Calcutta | 1 | 1421 | Medium |
EMP_ID | PAYGRADE | BRANCH_ID |
|---|
1 | Low | 105 |
2 | Medium | 102 |
3 | Medium | 105 |
4 | Medium | 103 |
5 | Low | 105 |
Data Coverage Analysis
You create a data coverage task and plot the regions on the X axis and the paygrade column on the Y axis.
The data that you plot creates the following data on the graph:
Region/Paygrade | Low | Medium | High |
|---|
East | 0 | 1 | 0 |
West | 0 | 0 | 0 |
North | 0 | 1 | 0 |
South | 2 | 1 | 0 |
There is more than one record in the cell that represents low paygrade in the south. The test cases that you run do not require data for low paygrades. You want to move data to the cells that represent high paygrade in the west and medium paygrade in the east.
You run a Fill Cell job to fill data in the cell that represents medium paygrade in the east. Choose to move one record from the cell that represents low paygrades in the south.
To perform this Move operation, the EMP_INFO table is updated. One record that has a Branch ID that represents the south and a low paygrade is edited. The move updates the paygrade to Medium and the BRANCH_ID to 103. No user input is needed as all the other data required is available.
You run a Fill Cell job to fill data in the cell that represents high paygrade in the west. Choose to move one record from the cell that represents low paygrades in the south.
To perform this Move operation, the EMP_INFO table must be updated. The operation must add a record that contains a branch ID for the west. The branch ID in the EMP_INFO table is a foreign key that points to the BRANCH_DATA table. The BRANCH_DATA table does not contain a record for the west region. A record for the west region must be added to the BRANCH_DATA table. The operation adds a record to the BRANCH_DATA table and populates the region ID as 2 for West. The BRANCH_ID information and other information cannot be populated and must be manually entered.
A user input dialog box appears with fields to enter values for the following columns:
- •BRANCH_ID
- •BRANCH_NAME
- •IFSC
- •FACILITY
Therefore this Move operation updates two tables. A row is added to the BRANCH_INFO table. Data is modified in the EMP_INFO table.