-
Outer Join "Not available with this engine"
Hello everyone I have two datasets that are imported from my PC, so they are not stored on any database. Currently, I am trying to outer join those two data sets; however, I am having this option disabled and showing an error saying: "Not available with this engine". Is there anyone way to overcome this error, or at least…
-
Duplicate removal
how can i remove duplicate row based on single column without python code
-
How to ingnore the Identity Column of SQL Server table in Dataiku
I have the SQL Server datasets as below TableSource has 2 columns [Name] string, [Address] string from connection 1 TableDest has 3 columns [Id] int identity, [Name], [Address] from connection 2 How to import data from TableSource to TableDest on Dataiku? Note: the connection1 and connection2 are on different SQL servers.
-
How to use selenium chrome driver in python recipe by authenticating thorugh digital cert
I need step by step help with installing chrome driver. I have already installed package selenium in my code env lets assume the name of the Code Env is "web_reports". Please provide the dependencies or guide to open an URL by authenticating via digital certificate. I want to download some reports from that website using…
-
What is globalExplanationsTopImportances ? How is it calculated?
I'm using the API to retrieve the following information for an regression model. details.get_performance_metrics()['globalExplanationsTopImportances'] This returns a dictionary list of dictionaries with keys and "s" and "d" as follows [{s:"Feature1",d:0.25},{s:"Feature2",d:0.15}] What value is given as d? What are the…
-
Develop Shiny app in code studio before deployment
Is it possible to use a code studio to take advantage of autocomplete, plugins, etc in order to create an RShiny app and then deploy it as a webapp? Specifically I would like to use RStudio. If so how would I do this
-
Using Group Recipe Without Aggregations
Hello everyone, I believe that python allows people to use the group_by() method without any aggregations; however, in dataiku, we must aggregate when we use the group recipe. In other words, I would like to group by a specific column and keep all other columns without aggregating, is that possible in any way? Note that I…
-
min between 2 dates
Hello, I'm trying to find the 1st date between 2 date fields. I was thinking of using a min formula but there may be missing values in these fields and the formula doesn't seem to work in this case. Is there another solution other than an "if then" formula ?
-
remapping connections for API services
Goodday! In the API Designer, we can define connections to use with SQL Query Endpoints. How do we remap these connections based on deployments to different API nodes? (ie. use different connection for deployments to a production API node vs. deployments to an acceptance API node) I don't see any option in the deployer UI…
-
Remove duplicate
Hi, I have gone through few of the post on the remove duplicate but none of that give the clear answer on the same. Can you pls. provide the path to showcase how can i use some column with condition if that value repeats it would stop counting the same value with entire row in the output? K.Rgds, Kalpesh