-
Problems joining tables
Hi, while doing a normal join on one table I run into this error "in act.compute_Base_Modelos_1_1_1_NP: Column name can not contain comma, quotation mark, leading or trailing white spaces with DSS engine (when using H2)." the problem is, even when I just use non coma, qm, and space columns to get the output I get the same…
-
Join that REMOVES matching rows
Hi, I have a dataset where some combination of columns results in a unique key: 1 A 1 B 2 B 2 C 3 A The first column with numerical values represents users and the second column with characters are their transactions. Each user has a unique identifier, but it is repeated in the file for every transaction. I am trying to…
-
Joins recipe on large datasets causing issue.
Hi @AlexT , I am using join recipe and there i am joining tow datasets one of the dataset has 7M records. It is caching that dataset in memory and running for longer period of time and later I am getting out of space issue. Kindly help me how I can resolve this issue. Regards, Ankur.
-
Left join of empty dataset
Hi, I have a join recipe (left join) where one of the joined table is empty (it is calculated sucesfully but empty). The recipe fails with an ERROR that the input dataset is not ready. How to avoid this error? Thanks
-
When trying to join two datasets I get the following error
I am getting error while doing JOIN recipe When trying to join two datasets I get the following error: Job failed: in act.compute_BASE_TRACKER_JOINED_STIRandMilestones_NP: Column name can not contain comma, quotation mark, leading or trailing white spaces with DSS engine (when using H2)
-
Analyzing person data along with picture
Hi, I am new to DSS and I have a requirement where I want to analyze a person call records along with with vehicle details etc. I need to see who that person is in contact with and what vehicle he owns and how he looks like (his picture). If i put a person ID or phone#, i should be able to retrieve all his information and…
-
Joining datasets error but columns do not have issues mentioned in the error message
When trying to join two datasets I get the following error: An invalid argument has been encountered : in act.compute_1stOAMatrix_NP: Column name can not contain comma, quotation mark, leading or trailing white spaces with DSS engine (when using H2). However, both datasets do not contain comma, quotation mark, leading or…
-
Join: All tables are in SQL DB but Dataiku can't use SQL as execution engine
If a dataset is imported in Dataiku using "SQL query" as Mode it's not possible to use the SQL as execution engine for further operation even if all the tables involved are in the same SQL Database: I think that since all the data is in the SQL database it should be able to use sql as the execution engine.
-
Possible to make Datasets join with "contains" condition ?
Hi all, I'm pretty new to Dataiku, and I'm currently trying to join 2 datasets. I found the Join recipe. However, my join condition is not "equals" but "contains". And when I choose this "contains" condition on datasets join, I have this error : "DSS can only join with equality conditions" Any idea how I can do this please…
-
Double key join results in blank dataset
I am trying to joint two csv datasets based on two numeric keys. Checked consistency between meaning and data format, and all kinds of different types of join, and in all cases I get a log saying over 340 thousand records have been added, but no row is shown in the explorer. Always says "no matching rows", even though I am…