error in using split recipe
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!