Survey banner
The Dataiku Community is moving to a new home! New posts are now disabled and the community will shortly be in temporary read only mode: LEARN MORE

Formula

douha
Level 1
Formula

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]

0 Kudos
1 Reply
ThomasW
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,

0 Kudos