Formula

Options
douha
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
    ThomasW Dataiker, Dataiku DSS Core Designer, Dataiku DSS Adv Designer, Registered, Product Ideas Manager Posts: 5 Dataiker
    Options

    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,

Setup Info
    Tags
      Help me…