Null or Missing Values in the Lookup Field
When valid lookup values are provided in the .csv file, they are correctly mapped and inserted into the Big Table records.
When invalid values are entered, the corresponding Big Table record is not created, and an error file is generated for the record.
When using values likenull, NULL, Null, 'null', 'NULL',
'Null', empty string (""), or blank, the lookup field should be
assigned a null value.| Data in the .csv File | Data Inserted into the Big Table Record |
|---|---|
| null | The lookup field should be assigned a null value or blank. |
| NULL | The lookup field should be assigned a null value or blank. |
| Null | The lookup field should be assigned a null value or blank. |
| "null" | The lookup field should be assigned a null value or blank. |
| "NULL" | The lookup field should be assigned a null value or blank. |
| "Null" | The lookup field should be assigned a null value or blank. |
| "" | The lookup field should be assigned a null value or blank. |
| The lookup field should be assigned a null value or blank. | |
| 701Rt00000yrPtmIAE (correct value) | The lookup field is assigned the correct value. |
| 701Rt00000yrPtmIAE123 (wrong value) | The Big Table record is not created, and a .csv error file is
generated with a message. For example: Bad Value - CSV column
"Campaign" mapped to BT Field "Campaign" :: Campaign: id value of
incorrect type: 701Rt00000yrPtmIAE123 |