Formula
douha
Registered Posts: 1 ✭
how to concatenate for exemple the first 10 characters of the column [CRIBINV], followed by the entire value of [CRD6002], and then the last 10 characters of [CRIBINV]
Answers
-
ThomasW Dataiker, Dataiku DSS Core Designer, Dataiku DSS Adv Designer, Registered, Product Ideas Manager Posts: 5 Dataiker
Hello @douha
,In a prepare recipe, by using the formula processor, something like this should work: concat(substring(CRIBINV,0,10),val("CRD6002"), substring(CRIBINV,-10))
Thanks,