The data that you plot creates the following data on the graph:
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:
Therefore this Move operation updates two tables. A row is added to the BRANCH_INFO table. Data is modified in the EMP_INFO table.