Excel boolean error

dialpemo
dialpemo Registered Posts: 5 ✭✭✭✭

When uploading an Excel file sheet with a TRUE or FALSE , boolean value the following error occurs

  • Used /bool_test_dataiku.xlsx (9.08 KB) to parse data
  • Used format excel but not OK: FORMAT SETTINGS
    Operating system used: ubuntu-20.04.4-live-server-amd64

Answers

  • tgb417
    tgb417 Dataiku DSS Core Designer, Dataiku DSS & SQL, Dataiku DSS ML Practitioner, Dataiku DSS Core Concepts, Neuron 2020, Neuron, Registered, Dataiku Frontrunner Awards 2021 Finalist, Neuron 2021, Neuron 2022, Frontrunner 2022 Finalist, Frontrunner 2022 Winner, Dataiku Frontrunner Awards 2021 Participant, Frontrunner 2022 Participant, Neuron 2023 Posts: 1,598 Neuron

    @dialpemo
    ,

    just a quick thought.

    Dataiku DSS can be a bit finicky about it’s Boolean values. I don’t think that all upper case TRUE and FALSE are valid Boolean values from DSS’s point of view. If you can’t change these in the source you may need to bring this column in as text and then convert to Boolean in DSS. If I remember correctly lower case true and false are what is needed, or it might be camel case True and False.

    Let us know how you get on with this.

Setup Info
    Tags
      Help me…