0 votes
Problème rencontré lors d'une requête sur un champ string  (filtre pour conserver uniquement des dossiers 2017)



substring("sdoss_numdoss",2,4)=="2017"  (ou substring("sdoss_numdoss",1,4)=="2017" )

message en-dessous : "Formula is valid"


(structure du champ sdoss_numdoss =  P201704160494SIA)

résultats --> 0 observation

1 Answer

0 votes
You don't need quotation marks around the column name.

Also, you should try without the boolean test to see what the substring outputs.

Anyway, substring(sdoss_numdoss, 1, 5)=="2017" should work.
i tested but it doesnt work

substring(sdoss_numdoss, 1, 5)=="2017"

and 0 result
Did you try without the boolean test? See what the substring outputs?
mistake  , last dataset wasnt update and was empty...

substring(sdoss_numdoss, 1, 5)=="2017" works !

thank you
Coming soon: We’re working on a brand new, revamped Community experience. Want to receive updates? Sign up now!
1,328 questions
1,350 answers
11,898 users

©Dataiku 2012-2018 - Privacy Policy