Using Dataiku
Sort by:
61 - 70 of
106
- When I use formula in preparation, i choose the Time Zone to Asia / Jakarta and expect the original time (in UTC) will change to GMT +7, but seem DSS do incorrecly: Original Date: 2018-01-22T12:02:55.…
Solution by Clément_StenacHi,
Actually your input date is already parsed and does not need parsing (see that it already has meaning "Date").
By removing the timezone from the pattern (because you put it as a constant), and selecting Asia/Jakarta in the parse step, you're actually telling it "ignore the timezone already specified in the date, and consider that the untimezoned thing that you just read is in Jakarta".
Then, DSS always currently displays the parsed date in UTC. So you parsed "noon in Jakarta", which indeed corresponds to "5 AM UTC", which is what DSS shows.
If you want to do the opposite, ie display this UTC date in the Jakarta local time, you need to use a "Format date" step instead of parse date, and select Asia/Jakarta as the time zone thereSolution by Clément_StenacHi,
Actually your input date is already parsed and does not need parsing (see that it already has meaning "Date").
By removing the timezone from the pattern (because you put it as a constant), and selecting Asia/Jakarta in the parse step, you're actually telling it "ignore the timezone already specified in the date, and consider that the untimezoned thing that you just read is in Jakarta".
Then, DSS always currently displays the parsed date in UTC. So you parsed "noon in Jakarta", which indeed corresponds to "5 AM UTC", which is what DSS shows.
If you want to do the opposite, ie display this UTC date in the Jakarta local time, you need to use a "Format date" step instead of parse date, and select Asia/Jakarta as the time zone there - Good afternoon, Is it possible to get the first character as 0? For example i have two numbers 24567 and 02456, so i tried the fonction get (x,0,1) but at the sacond case its giving to me "2" instead …Solution by Clément_StenacHi,
Formula will always autocast when referencing the column directly, even if the storage type is string. To avoid that, replace x in your formula by strval("x")
So it would look like: substring(strval("x"),0,1)Solution by Clément_StenacHi,
Formula will always autocast when referencing the column directly, even if the storage type is string. To avoid that, replace x in your formula by strval("x")
So it would look like: substring(strval("x"),0,1) - Hi Team, I have series of sets for my Recipe. I would like add one new step in between step 10 and 11. Would it be possible or just guide on how to do this ? Regards, Nantha.Last answer byLast answer by Clément_StenacHi,
You cannot add a step at a given location but you can reorder steps by grabbing them by the handle on the left - Hi, I don't understand why in a prepare recipe, the sum of 2 values rounded at a single decimal can be a number with more than one decimal ?Solution bySolution by Clément_StenacHi,
DSS, like many other software, uses floating-point arithmetics (https://en.wikipedia.org/wiki/Floating-point_arithmetic).
One of the main characteristics of this kind of computation is that it uses a fixed amount of memory to represent all numbers, and thus cannot represent numbers with an infinite precision.
Due to details of how these numbers are represented, some rounding issues can always happen when doing computations, even very simple ones, because the result might not be representable exactly.
A quite famous example of this is 0.1 + 0.2, which is not equal to 0.3 in floating point arithmetic but 0.300000000004
You will need to reformat your number, as shown here: http://answers.dataiku.com/1027/change-precision-of-double-number - Hello, I'm Dataiku and ML beginner, so excuse my (maybe) simple question. I have a dataset with data on internet companies. Originally it came with ">" and "," separated info on target markets (column…Last answer by
Last answer by wodeckiThank you
- Hello. I have numbers in a dataset that look like this: 1.6199999999999974 I want to reduce the precision to 3 decimal places. I saw there is a format function for strings, but didn't see anything sim…Solution bySolution by Clément_Stenac
Hi,
Use the "Formula" processor in data preparation, with a formula like:
format("%.3f", my_column_name)DSS formula use the Java variant of format strings:
https://docs.oracle.com/javase/7/docs/api/java/util/Formatter.html#summaryFor more information about formulas, see:
https://www.dataiku.com/learn/guide/code/misc/formula-master.html
http://doc.dataiku.com/dss/latest/advanced/formula.html - Hi Team, I have value of 12.6666666 and I want to reduce the precision to a. 12.66 ( for one column ) b. 12.67 ( for another column ) how can do this Via Processors and formula. Regards, Nantha.Last answer byLast answer by Clément_Stenac
- Hello! I have a question according the cleaning data. I have the colomnes with names and surenames and some times i have some numbers with the text information, as: NOM PRENOM Soloma Anastasiia2 Ri5gr…Last answer by
Last answer by AnastasiiaSolomAh exact! Thank you very much for such fast answer!
Have a nice day - Hello friends, I'm trying to group the dataset as shown below, but I'm not getting it. I think it's possible to use a custom key, but I don't know which SQL Expression to use. Has anyone ever had to d…Solution by
Solution by Alex_ReutterI think STRING_AGG() is what you're looking for: https://www.postgresql.org/docs/current/static/functions-aggregate.html. - I have a column as such: [{"country":"US","uid":"5419068","amount":"34389.38 ... And would like it as so: country | uid | amount US | 5419068 | 34389.38Last answer byLast answer by Clément_StenacStart by using the "extract from array" processor to extract the 0th element of the array. Then use the "Unnest object" to transform object keys to columns.
If you want each element of the array to form a new line instead of taking only the 0th, then use instead the "Fold array" processor which creates one line per element of the array
61 - 70 of
1067