Using Dataiku
- How do I set up two conditions? I tried this: Product == 'EB' and parseJson(stepOutcome_DroppedPols_EB) == 'SUCCESS' and this: and(Product == 'EB', parseJson(stepOutcome_DroppedPols_EB) == 'SUCCESS') …
Solution by TurribeachPS: Note that you will most likely want to use this expression:
condition1 && condition2 && conditionN && outcome == 'SUCCESS'
Read the Pro Tip section of this post to understand why. You can also use brackets and combine with the Or boolean operator || as follows:
(condition1 || condition2) && condition3
Finally the boolean functions of Dataiku's formula language can also be used here but I prefer the boolean operators since it makes the expression more readable:
and(or(condition1, condition2), condition3)
Solution by TurribeachPS: Note that you will most likely want to use this expression:
condition1 && condition2 && conditionN && outcome == 'SUCCESS'
Read the Pro Tip section of this post to understand why. You can also use brackets and combine with the Or boolean operator || as follows:
(condition1 || condition2) && condition3
Finally the boolean functions of Dataiku's formula language can also be used here but I prefer the boolean operators since it makes the expression more readable:
and(or(condition1, condition2), condition3)
- Hi, I am trying to control a python continuous recipe with the test of a global project variable. I have tried this: … response = requests.get(url, headers=headers, stream=True) if response.status_cod…Last answer byLast answer by Turribeach
Can you try using this code to get the project handle?
import dataiku client = dataiku.api_client() project = client.get_default_project()
The rest should be the same.
- I have 2 datasets, in one I have one column with duplicate IDs and in the other one i have the ID without duplicates, but i want to sum all the candies into the dataset where i don't have any duplicat…Last answer byLast answer by Turribeach
Use Group recipe on the dataset with duplicates, group by the ID column and sum your candies. Then join the output dataset to the dataset without duplicates using the ID so you can add your aggregate column.
- Hi, I want to send an Alert/Notification to check max timestamp value on a dataset and and send an alert message if the date has not been updated for last 10 days. Thanks for help! Operating system us…Solution bySolution by Turribeach
Try with this date format in the formula:
yyyy-MM-dd'T'HH:mm:ss.SSSSSSZ
- Hello, when I am printing a dataframe before I save the output with write_dataframe() or write_schema_from_dataframe() and check the counts on the dataset object, it does not match. Why does it not ma…Last answer byLast answer by Turribeach
Please post your Python recipe code in a code block (the </> icon). Also are you rerunning the notebook from scratch?
- Hello, I have a problem in my Dataiku flow, I want to convert a number from raw to French format And in the output dataset, all the numerical variables are NaN. Can someone help me to fix the issue ? …Last answer by
Last answer by SarinaHi @HL,
Can you attach a screenshot of your prepare recipe "Convert number formats" settings, along with a screenshot showing the column you are attempting to convert before and after conversion?
Thank you!
Sarina - Hi, I need to designate a new flow zone as the default and delete the existing default flow zone. I don't see any way to do this?Solution bySolution by Turribeach
Well one work around this limitation is to swap all the items between the default zone and the new zone you want to be set as default. If you press shift you can multi-select flow items and move them all at once. A temp zone is advisable to use a pivot to avoid mixing your zone items.