question on prepare recipe

NN

Hi All,

I had 2 questions on the prepare recipe.

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

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 ?

Mateusz

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

Thanks

Mateusz

Alexandru

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}$

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}$

CoreyS

Hi @NN
while I can't provide a solution to your specific questions, I just want to make you aware, if you haven't accessed them already, of the Advanced Prepare Recipe Usage course in the Dataiku Academy. Also some other resources in both the Documentation on Data Preparation and in the Knowledge Base on Data Preparation as well.

I hope this helps!

NN

Thanks @emate
and @AlexT
and @CoreyS

The (?i) option works perfectly
And the external comment is the best alternative . Thanks for your inputs.