Data Handling Scenarios
Overview
When importing a .csv file, the system supports various data handling scenarios to ensure accurate mapping and insertion into the Big Table. The logic is based on the presence or absence of values in the .csv file, the Big Table mapping, and the "Add Fixed Value" panel.
Scenarios
| Scenario (Case) | Condition | Result (Big Table Field Value) | Priority Rule |
|---|---|---|---|
| Case 1: Value in Both .csv and Fixed Field | Both the .csv column (mapped to a Big Table field) and the "Add Fixed Value" field have values. | The system prioritizes and uses the value from the .csv file. | The .csv Value is prioritized. |
| Case 2: Value Only in "Add Fixed Value Field" | The .csv column mapped to the Big Table field is empty, but the "Add Fixed Value" field has data. | The system inserts the value from the Add Fixed Value panel field. | Add Fixed Value is used when .csv is empty. |
| Case 3: Mixed Values Across Rows | Both .csv and Add Fixed Value fields have data, but some rows in the .csv column are blank for the field. | For each row where the .csv field is blank, the system uses the Add Fixed Value. | Add Fixed Value is used selectively for blank rows. |
Summary
- When both the .csv file and "Add Fixed Value" have data, the .csv value is prioritized.
- When some .csv rows are blank but "Add Fixed Value" has data, the "Add Fixed Value" data is used for the blank rows.
- When only "Add Fixed Value" has data, that value is inserted.
| Scenarios | Field Fixed Value | The .csv Row Has Value for Column? | Big Table Field Value | |||
|---|---|---|---|---|---|---|
|
When the .csv file column is mapped |
Fix-Val1 | Yes (R1Val1) | R1Val1 | |||
|
When the .csv file column is NOT mapped |
Fix-Val1 | Yes (R1Val1) |
|