How is true / false field stored in Aperture?
Note that the data below is business data and not PII.
Issue: When I import the CSV file created in Aperture into PowerCurve Assisted Strategy Design, it does not recognise the values in the CSV file as being text “TRUE” or “FALSE”.
If I copy the values in this column and paste them into the same column as Values, then it works.
Question: What is the actual value stored in this column when generated in Aperture that it is not read as text true/false, but appears to be text true/false?
Transformation done on CustomerCVR field:
How the resulting column looks in Aperture:
How the resulting column looks in Excel (the exported csv file created using Export to CSV function in Aperture workflow)