Search results

hi J, nice to hear from you! you must: * Put a MultiThreadRun box before and after the R script * Set the "number of thread" parameter to 2 (or more) inside the MultiThreadRun box located AFTER the R script. To find the optimal number of threads: run some tests and measure the graph execution...

Great to hear from you! I think that you are searching for the box named "concatString": see the example in the attachment.

hi, there is no option that does this in one mouse click but it can easily be done in a few boxes: see the graph attached. I have also attached another graph which is similar and which can be use from time to time. cheers

hi Thomas, it's easy! in the graph attached you can see that this is just a "calculator" to calculate the lengths and then an "aggregate" to take the "max()". Then to make the same but dynamically: you can use the short flow below with a dedicated coded box, as input on pin 1, to pass the name...

hi Dan, To remove this error, uncheck this checkbox:

Hello Lucy, please have a look to the below image and the graf attached for an example. It will create 2 directories based on the content of the column "C2". For this to work properly, you need to set these 2 parameters properly

yes off course, please see attachment

Hello Johan, By default, the "key" keyword is forbidden in SQL. This is why Anatella is preventing you to use this specific keyword. This is why Anatella displays the above error message. Just use another column's name and you'll be fine (e.g. rename the column "key" that you are trying to...

Yes! The box that you describe is already there: You are searching for the option named "Create NULL column if column is missing" inside the "ColumnRename" box: See the file in attachment for a complete working example.

Hi Alex, Looking at your error message, we see that Anatella stops because Anatella cannot find the python engine located in the directory: C: /soft/TIMi/Python/python36.dll Without proper configuration, python boxes do pose a problem in Jenkins. ... But that's not the only thing that can mess...

Hello Jurrit, this is the expected behavior from Anatella. This is to handle the very common situation where people want to convert "85€" or "85$" to the number 85. To do the data-type-conversion in the exact way that you want: See the graph in attachment.

The 1st thing is to make sure your DBA gave you the writing right in the DB Then to tick the advanced parameter “allow null SQL result” Finally I’d suggest to add the “SET NOCOUNT ON “ at the start of the SQL script SET NOCOUNT ON DECLARE @tableTemp Table(id int, amount int) INSERT INTO @...

Hello Xavier! It's actually quite destabilizing as a situation! The SQL command which contains the "TARGETID>1000" is executed by your database (and not by Anatella). In fact, Anatella just transmits "as is" the text of the SQL command to the database without understanding it and it is the...

Hi Xavier, The column "CATALOGKEY" is too big to be manipulated as a number (there are more than 14 digits: we are beyond the accuracy of the machine on floating point numbers (the "double")): you have to manipulate it like a String: ie: Make alpha-numeric sort ('A') and not numeric ('0') The...

Yes. To be sure to see the whole number (after conversion to string), use "%.16g" when converting: More details (with examples) on page 235 of "AnatellaQuickGuide.pdf".

Hi Tri, In the "data preview", the columns of type Float (on a blue background) are displayed using a maximum of 6 digits behind the decimal point (this corresponds to the display "% .6g" which is described here). In summary, Anatella tries to use up to 6 digits to display the number. The value...

Hi Jérome and thanks for you query! In general, one creates a "technical user" (for example named "JenkinsUser") who has "extended rights". For example, what we absolutely want to avoid "in production" (ie for an Anatella job that runs in Jenkins), is that the job stops because the job involved...

Hello, please find below our current answers: Security Questions Are user passwords must be stored using a Salted Cryptographic Hash? Yes, when it's possible. For example, the ODBC password to connect to relational database is encrypted using a symmetric algorithm with a 196 bit key. The...

hi, in the "readcsv" box, you can use the specific setting as per below screenshot:

hi Marie Ange, please find attached the graph to calculate the MACD indicator :D