question on prepare recipe
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 ?
Best Answers
-
Mateusz Dataiku DSS Core Designer, Neuron 2020, Registered, Neuron 2021, Neuron 2022 Posts: 91 ✭✭✭✭✭✭
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 Dataiker, Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Dataiku DSS Adv Designer, Registered Posts: 1,212 Dataiker
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}$
Answers
-
CoreyS Dataiker Alumni, Dataiku DSS Core Designer, Dataiku DSS Core Concepts, Registered Posts: 1,150 ✭✭✭✭✭✭✭✭✭
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!