-
Currency conversion
I found the currency conversion step very helpful, but just realized that at some point in the past, historical exchange rates seem to be missing, which leads to amounts not being converted. I was wondering if there is a file that could be extended and uploaded to DSS to improve the currency conversion for historical data.
-
script formula left / right
Dear all, could you please hellp me with a script, how can I devide the information according the rule: I have the email asolomatina@valeo.fr I know that domaine is n.surename@ How can i Divede to different colomns the domaine from email to have in the first colomn "a" and at the second one "solomatina"? Thank youin…
-
How can I find and modify the "correct" country list?
Using country data from different sources, I have trouble getting the country names the way DataIku wants them. Since there are different (often legitimate) spellings for many countries, it seems like a waste of time to have to clean them up in the way DataIku wants - especially when it may be difficult to guess what name…
-
Visual bug in "prepare" view precluding sample size configuration
I have trouble with the visual presentation in the "prepare" view. The problem is that the name of the current dataset is displayed with very large characters, hiding other elements (besides being unreadable), and most importantly, it makes it impossible to change the sample size - with the result that some operations…
-
After creating a group of steps in one recipe, can I use that group in another recipe?
I want to process several datasets in the same way, I have put all the steps (but one, which should be individual) of one recipe into two groups, which I now want t use for several other datasets. Is that possible and if so how?
-
How to parse improperly concatenated data set with missing nulls and delimiters into correct columns
I need to parse a dataset with incorrectly concatenated fields of vendor data crammed into one "trouble" cell per row. I have cleaned up the prior columns to the left except for the column with these "trouble" cells. All of the data within the concatenated cell technically is correctly ordered, and the groupings of columns…
-
Oversampling Dataset
Is it somehow possible to oversample my dataset? for example, I have such records and target variables 1 2 3 | 5 2 2 3 | 6 1 1 1 | 1 3 2 2 | 5 I want to duplicate (or generate more than one duplicate) row #3 and make my dataset looks as follows: 1 2 3 | 5 2 2 3 | 6 1 1 1 | 1 1 1 1 | 1 3 2 2 | 5 How can I do this? Thank you…
-
Every recipe i run FAILS
Hello, I have used Dataiku last year and a few days back i restarted using it but everytime I try to run a recipe (whether it is prepare or join) the job always fails! It says activity was successful and I can see the output dataset but then it has errors in computing metrics and I am never sure if the recipe actually…
-
Add undefinite number of characters to strings
I have a string column with a number of chars in it that can be up to 10, I need to fill the beginning of each cell with "0"s so that each cell is 10 chars. So, for instance, transform this 12345 3948 36 1234567890 48975646 Into : 0000012345 0000003948 0000000036 1234567890 0048975646 How can I do that ? (Can't use SQL)
-
DSS output to build a datawarehouse
Hi, Can I load the data source from one database (a postgresql database), after data cleaning on DSS then output it to another database (also a postgresql) Thanks,
