-
Number of Rows
Hello, I am using Dataiku Dss for managing for the organization I am working now. The idea is I am collecting above 230000 records (rows) by using Kobo Form. I use API to import the data from Kobo to Dataiku. Currently, I have above 50,000 records on Kobo but am able to get only 30K rows on Dataiku. Is there any way to get…
-
In python Webapp pass global variable of person logged in and interacting with the app
Hi Everyone, I did look through existing discussions and I have not see exactly the answer I'm looking for. Either in a python notebook, and by extension a python Webapp, I would like to grab the DSS user id that is currently logged in and interacting with the webapp in a variable. My use case, is I created a webapp where…
-
Use file from code env resources directory with API Test queries
I've built a python API endpoint that uses a certain code environment. In the resources folder of that code environment is a file. If I run the API code in a notebook using that code env, I'm able to access that file. But when I run Test queries in the API Designer, the file cannot be found. The code used is the same in…
-
issue in loading data in to teradata
I don't understand the issue in loading data in to Teradata , for same I'm able to .csv data set which is successful. might be some characters but its not strange characters , #,-,',(,/ [Teradata JDBC Driver] [TeraJDBC 16.20.00.13] [Error 1338] [SQLState HY000] A failure occurred while executing a PreparedStatement batch…
-
How to get the value before a specific delimiter
If I have a string value formatted as firstname_middlename_lastname_initials_age_gender and I only need everything before age, is there a formula I can use to give me everything before the fourth instance of my delimiter "_"? I know I can probably use the split function to split them all apart and then concat together the…
-
How to pivot from column to rows
I have data that has a column with the days of the week, source and season. I'm trying to split my days column to rows. I have picture of my current input and expected output. I tried to use the split function but that split the days into different columns not rows. is there a way to get my desired output using dataiku?…
-
How to filter dates less than current day
I have a dataset that has a list of dates and days of the week, is there a way I can filter my dataset for dates that are less than or equal to the current date? I tried the formula date = now() but I don't think that's working, it just filters all my data out. Operating system used: windows
-
Suggestions on deploying an End Point
I have a dataset with content and URLs, I have created embeddings for this content and saved in a new dataset, so it now has the embedded content and the URLs, I want to create an API which can send content and I embed this content and perform a similarity search on the embedded dataset and give the top 3 matched URLs, I…
-
Defining a variable before scenario starts
Hello everyone! This past week, I've been working on a project where I've implemented a scenario reliant on database modifications. However, the issue is encountered when you need to redefine the same variable every time the scenario runs. This process involves loading a huge dictionary and AI models, consuming 2-3 minutes…
-
Conditionnal formating - Dashboards
Hello, I would like to add some colurs into published dashboards of my project. For instance, if the number is equal to 0, the cell should be highlighted in green... Does someone know how to do that ? Thank you !
