Search results

  1. Support

    column with an incremented serie

    hello, attached you can fin a graph that does just that !
  2. Support

    Has Anatella an event driven architecture (such as in Azure Data Factory?)

    You can indeed react to "events" with TIMi/Anatella and perform "event driven" actions. There are basically, four mechanisms to react to events inside Anatella: 1. the "build triggers" inside Jenkins. Jenkins is one of the most well-known open source scheduler available today...
  3. Support

    HD cache write buffer is too smal

    You have to increase the value here until it gets through :
  4. Support

    ERROR upsertODBC: cannot find column

    This error appears when you activate the "Row Selection" option without specifying a column to test here: Don't hesitate to contact us again if you run into any more trouble.
  5. Support

    IF, THEN function

    Hello Yaroslav, That's great to hear from you! For a solution: see the graph in the attachment.
  6. Support

    several variables in several places in the graph?

    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 ">"...
  7. Support

    Dates with the calculator?

    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.
  8. Support

    SET "global parameters" from a database

    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:
  9. Support

    How to design new data transformation and Run/integrate Anatella in our company?

    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...
  10. Support

    another New Hardware Id on a new machine after my initial request

    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...
  11. Support

    TRIM in GetGlobalParametersFromFile" box

    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...
  12. Support

    Anatella rounding

    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...
  13. Support

    input and output data visualisation in Anatella

    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
  14. Support

    transform hours into expression

    hi bernard, please see the attached graph
  15. Support

    CSV: transform the string into float Anatella and keep the value

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

    start reading the table in a specific row for a .CSV

    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)
  17. Support

    neper number to be displayed as a capital “E”

    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
  18. Support

    Key that resets based on a column value

    Hi Jerome, See the solution in the attachment
  19. Support

    Simple Sum of float columns with null values - but using less complex formula?

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

    changing numbers datatype to float

    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...
Top