error in using split recipe

[Ankur5289]

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?

[Ankur5289]

Solved this .:)

[CoreyS]

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!

[Ankur5289 · Accepted solution]

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