question on prepare recipe

NN
NN Neuron, Registered, Neuron 2022, Neuron 2023 Posts: 145 Neuron

Hi All,

I had 2 questions on the prepare recipe.

1. Is there a way to add comments to a formula

temp1.jpg

2. in a find and replace function i wish to select the columns using a pattern.
is there a way we can make this column pattern search case insensitive ?

temp2.jpg

Best Answers

  • Mateusz
    Mateusz Dataiku DSS Core Designer, Neuron 2020, Registered, Neuron 2021, Neuron 2022 Posts: 91 ✭✭✭✭✭✭
    Answer ✓

    Hi @NN

    When it comes to your 1st question - adding comments - I would just add a "comment" this way, and I would aslo tick an option "always show comment" - that way under this specific "prepare" recipe I would see a comment

    image.png

    Thanks

    Mateusz

  • Alexandru
    Alexandru Dataiker, Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Dataiku DSS Adv Designer, Registered Posts: 1,217 Dataiker
    Answer ✓

    Hi,

    To answer you second question around regex pattern you can use the following to make the whole pattern case insensitive using (?i)

    Example : (?i)^mobilename_\d{1,3}$

    Screenshot 2021-05-14 at 10.23.08.png

    In cases where you don't wont the whole pattern to be case insensitive you add UPPER/lower case within e.g [Aa]

    your example : ^[Mm][Oo][Bb][Ii][Ll][Ee][Nn][Aa][Mm][Ee]_\d{1,3}$

Answers

Setup Info
    Tags
      Help me…