error in using split recipe

Options
Ankur5289
Ankur5289 Partner, Dataiku DSS Core Designer, Dataiku DSS & SQL, Dataiku DSS Core Concepts, Registered Posts: 27 Partner

When we use the below formula it shows formula as valid but overall it displays as errors encountered.

idataiku_split.PNGdataiku_spplit2.PNG i am using the split recipe with DSS formula. can some one tell me why i am getting this error?

Best Answer

  • Ankur5289
    Ankur5289 Partner, Dataiku DSS Core Designer, Dataiku DSS & SQL, Dataiku DSS Core Concepts, Registered Posts: 27 Partner
    Answer ✓
    Options

    @CoreyS
    the query was defined as length("SOURCE") so it was treating SOURCE as a string and not as a column of the dataset.

    And again "DEST" was also treated as String. so there was mismatch in length of the two columns. SOURCE has 5 characters and DEST has 4 .

    What i did to resolve this was as below :

    length(SOURCE)==3 && length (DEST)==3

    removed all the double quotes and now its working fine.!

Answers

Setup Info
    Tags
      Help me…