-
How to remove a certain string form string text data?
Hello experts, Please help me following question. I have a string column like: ABCDC01 ABCD02 ABCD03 AAAA ABCD04 BBB Now, I would like prepare to create a column copying above string, but I want to remove specific string "ABCD" thus expected data should be: 01 02 03 AAAA 04 BBB How can I do this? Thanks in advance.
-
Best approach to appending daily data from files?
Hi everyone! I want to see your input on the best approach to do the following: I have daily CSV files that contain no date column, but values change on a daily basis. I want to create a dataset based on these files. I will be added files every day. I need to add a date column to the file of the date it was added. I…
-
Call external API based on dataset row
Hello, We have a scenario where we want to use the rows in a Dataiku dataset as input to an external API call and then have the results of that external API call either added to the existing dataset or create a new dataset that includes the data used in the request and the response. Can you provide guidance on how this…
-
Trend my data
Dear community, I have a chart with date values on the X axis and number of events on the Y axis. I would like DataIku to superpose a linear trend line, what in Excel would be done through the TREND function. ¨The Excel TREND function is used to calculate a linear trend line through a given set of dependent y-values and,…
-
Bug report: Group By
Hi all, Not sure the best place to make a bug report, so I'm posting it below: When using the group by visual recipe, in the event that you change the case of the key that the recipe is grouping over, the underlying SQL query does not update properly. In my case this is Date_UTC -> date_UTC. It only happens when an…
-
Pyspark python issue:Py4JJavaError: An error occurred while calling o59.classForName.
Hello everyone, I am working on PySpark and I have mentioned the code and getting some issue, I am wondering if someone knows about the following issue? I get the error in the last line of code. mydataset = dataiku.Dataset(dataset name) df = dkuspark.get_dataframe(sqlContext, mydataset) Py4JJavaError: An error occurred…
-
Show Bar Chart Values when mouse is not hovering
Dear community, I'd like my charts created in Dataiku to show the dimensions, not only when mouse hovering. Is that possible? Please find attached a chart example, where I've written by hand in red the underlying dimensions I would like the chart to include. Thank you. Operating system used: Microsoft Windows
-
HDFS connectiion creation
Hi Team do we have any script present to create mutiple connection in go itself. We have to created more than 15 HDFS connection and tag mutiple groups to these connection. Manual approach towards it will consume a lot of time. if any one has any idea on how can you reduce the manual efforts around this. Operating system…
-
Time Series resampling using EOM dates, but I want month start
Is there a way to do the time series resampling by month where it uses the first day of the month (i.e. 2022-01-01) rather than the EOM? My data is already in first of month but resampling is forcing it all to the end. I played around with some option in the resampling but couldn't find a solution. Thanks! Operating system…
-
Recipent multiple Email in a scenario REporter
Hello, i managed to use this reporter to send email to a single address with a custom variable, but didn't found the information to the seperator to use to put other email it works with To : xxxx@email.com but didn't work with To : xxxx@email.com;yyy@email.com is there a documentation ?