Search results

Yes of course. This kind of variable is called "global parameters". You can define them here: ...and then they are available everywhere: that is: they are available: * in the calculator or the rowFilter directly * in all other fields of all other boxes using the special character ">"...

Hello Mark, When you want to manipulate dates using the calculator you have to do 2 things: * activate "_nowS" with the checkbox (see screenshot below) * set date format (see screenshot below) Here is an example: I have also attached this example.

yes, it is possible and it is even very common to define the content of "global parameters" from a database. You just need to make a slightly different graph: See the attached example:

Hello Jerome 1/ How to design some new Data Transformations inside Anatella? Typically, to design new data transformations (i.e. to design a new .anatella file), you can use: Anatella installed locally on your laptop. Anatella installed on a remote server and you access the remote server...

The change of HW/ID is caused by a configuration change in the network cards of your machine. To prevent this from happening again, you must run Anatella/TIMi at least one time when the laptop's internal wifi/ethernet card is turned ON (i.e. not on "disabled"). When Anatella sees an internal...

Hi Marc, Indeed You have to activate the trim manually. The new "trim" option is here: This new option is enabled by default when you add a new "GetParametersFromFile" box in your Anatella graph. On the other hand, it must be manually activated for all the "GetParametersFromFile" boxes...

Inside Anatella, there is no rounding anywhere (unless you use the "round()" function of the calculator, but that's normal). Especially if you use .gel_anatella files to save your data, you are guaranteed that everything is perfect, without any rounding. On the other hand, when you export to a...

I've put in the attached zip a sample graph ("Extract_Data_Flow2.anatella") that does what you ask. Basically: there are 2 interesting boxes: * a first box extracts all inputs/outputs from the given graphs * a second box "links" all inputs/outputs together to get all the dependencies

hi bernard, please see the attached graph

use a "replaceStrings" box to remove the comma's, like this screenshot (and see also the example in attachment):

Yes: just use a rowFilter box with the expression "_n>=5" (to skip the first 5 rows): See screenshot (and see also the example in attachment)

Since Anatela 2.67 there is a new options inside the writeCSV box to do that Also you already do that using a combination of 2 other boxes in the attachment

Hi Jerome, See the solution in the attachment

You can use a simpler expression: see the example in the attachment.

To summarize your request: You want the meta-type of all the columns containing only numbers to be changed to "Float". The solution is in the two graphs in the attachments. There are two graphs: * the first one is when the data to be converted is not inside a .gel file. * the second one is when...

Dear Bernard, You are searching for the box named "propagateDown". Here is an example: ...and the output is: The example graph is in the attachment.

To convert dates in "elapsed time" format (i.e. in "Number" format) to a "String" format, you have to use the changeDataType box again, but this time you have to go to the "to String" tab: for more details: see this screenshot: we also put an example in attachment.

we fixed your graph: see in the attachment. >error: column is not unique: duplicate value is... This is when the primary key in the slave (or "B") table is not primary: it has duplicates. In such situation, Anatella doesn't know which row from the slave table to add to the master table since...

Hello Bernard, You can choose the columns in Excel that contain dates here: In your case, you just need to add column "A" to the list of columns that are dates.

Hi Alex, use this expression inside the calculator to remplace nan and inf with "-1": "isFinite(x)?x:-1" see also the example in attachment. Cheers