ETL and Data Integration tools - Modern ETL software for everyone

I was trying to do some math using Transformation->Calculation->Calculation Properties->Editor
(I do understand some Pascal - use Delphi sometimes)

How do I reference my columns?
Also, I want to reference a previous value. How?

I have, for example, date based data and I have a column for today's last price called "Close".

I want, as a simple example, calculate average of yesterdays price and today's, like in metacode:

AvgClose:=(Close(0) + Close(-1))/2;

Where AvgClose is a value I want added to other written output data.
Would appreciate help with this.

Thanks,
Matt

Hello.

Have a look at Basic Calculation Examples in documentation.

Also, I want to reference a previous value. How?

To be honest I do not quite understand what are you trying to achieve.
May be all you need to do is to sort than group you data and calculate average?

Mike

Mike,

I will try to use the provided examples to understand calculator basics.

The second problem I do not think is solved by using grouping.

In the example I stated, I only wanted to do a moving average by referencing the previous record together with present, i.e. using previous data row - or more generally any row.

I want to know if it is possible, because it would simplify a lot and would help me do a lot of things I otherwise would use Delphi or Excel for. I can still do it that way, but I saw a really great potential here, if the database converter could be used to take care of more of my data transformations. They very ofter reference other rows or records than the present.

I'll play more with the program so that I can be more specific and experienced when I ask.

Thanks,
Matt

I see what you mean now

There is a function called Previous Value, which will do what you wanted.

Looking forward to more feedback from you,
Mike