Boolean Value Standardization
Overview
Import Rx standardizes the values in your .csv or .txt file into a simple True or False value in the Big Table record.
| Data in .csv File | Data Inserted in the Big Table Record |
|---|---|
| yes / Yes | True |
| no / No | False |
| y / Y | True |
| n / N | False |
| true / True | True |
| false / False | False |
| 1 | True |
| 0 | False |
What Happens with Invalid Values?
If you enter any value other than those listed above (e.g., "YCDE"), the record will not be created in the Big Table, and an error file will be generated. The error message will tell you that the data type is incompatible and list the accepted values.