Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
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 ?
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
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}$
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!
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
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}$