Recent content by jerome

  1. J

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

    Hi I have 3 questions 1/ How to design some new Data Transformations inside Anatella? 2/ How to run an Anatella Data Transformation? 3/ How to integrate Anatella inside our company's App?
  2. J

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

    let’s suppose that we have a CSV file that contains values as 1,589,254.3. Is there any configuration in the CSV action that is able to read correctly this figure? Currently, using the standard configurations, if we transform the string into float Anatella keep the cell empty instead of...
  3. J

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

    when we import a CSV file into Anatella is it possible to start reading the table in a specific row as for Excel files?
  4. J

    neper number to be displayed as a capital “E”

    The first question is related with all the computations done in Anatella that involve decimal numbers with several cases and therefore are written as e-10 for instance. When we extract the output as CSV file, we would like the neper number to be displayed as a capital “E” in the file. Do we have...
  5. J

    Key that resets based on a column value

    Hi Do you know if it is possible to have a simple key generated in Anatella, but that would reset each time a value in a column change. Let’s imagine a one column table that would contains the following values. Column1Name ValueABC ValueABC ValueABC ValueXYZ ValueXYZ Value123 Value123...
  6. J

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

    Hi Is it normal that in order to process a simple sum of float type columns that contains sometimes null values,I am forced to use such a complex formula (see below in yellow)? Or am I doing something wrong here? Not using the IsNull formula, or even just not using the parentheses in my formula...
  7. J

    changing numbers datatype to float

    I wanted to know how to have the box “ChangeDataType”, doing nothing for each column where a strict string to number conversion has not been possible for at least one value of the column. Basically, the columns where at least one value would fail to be converted, would remain (the whole column)...
  8. J

    SQL via OBDC

    I take the opportunity to have your attention : Via the odbc reader I try to pass a T-SQL of this type, but the output is null: DECLARE @tableTemp Table(id int, amount int) INSERT INTO @ tableTemp SELECT id, amount FROM table_existante WHERE id < 100 SELECT id FROM @ tableTemp But when I do the...
  9. J

    Python environment set up via Jenkins?

    How to properly Set up a Python environment Python in Anatella via Jenkins?
See more
Top