Announcing the winners & finalists of the Dataiku Frontrunner Awards 2021! Read their inspiring stories

error in using split recipe

Solved!
Ankur5289
Level 3
Level 3
error in using split recipe

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?

 
 
0 Kudos
1 Solution
Ankur5289
Level 3
Level 3
Author

@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.!

View solution in original post

3 Replies
Ankur5289
Level 3
Level 3
Author

Solved this .:)

0 Kudos
CoreyS
Community Manager
Community Manager

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!

Looking for more resources to help you use Dataiku effectively and upskill your knowledge? Check out these great resources: Dataiku Academy | Documentation | Knowledge Base

A reply answered your question? Mark as ‘Accepted Solution’ to help others like you!
0 Kudos
Ankur5289
Level 3
Level 3
Author

@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.!

View solution in original post

A banner prompting to get Dataiku DSS