Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
error in using split recipe
Added on September 9, 2021 6:57AM
Likes: 0
Replies: 3
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.
i
i am using the split recipe with DSS formula. can some one tell me why i am getting this error?
Best Answer
-
Ankur5289 Partner, Dataiku DSS Core Designer, Dataiku DSS & SQL, Dataiku DSS Core Concepts, Registered Posts: 27 Partner
@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
-
Ankur5289 Partner, Dataiku DSS Core Designer, Dataiku DSS & SQL, Dataiku DSS Core Concepts, Registered Posts: 27 Partner
Solved this .:)
-
CoreyS Dataiker Alumni, Dataiku DSS Core Designer, Dataiku DSS Core Concepts, Registered Posts: 1,150 ✭✭✭✭✭✭✭✭✭Thanks for letting us know and good to hear you solved this @Ankur5289
. I’m curious, what was you solution? It might be good for others to share in some of your 🧠 power!