ETL and Data Integration tools - Modern ETL software for everyone

Is it possible to use transformer to write to a specific field based on the condition of the value.

For example, in my reader I can have negative or positive values in a specific field. If the value is negative, I would like to write it to a Credit Field, and, if it is positive I would like to write it to a debit field.

example:

reader field [Amount]
Write Field [ Debit] or [Credit]

Amount = 100 -> Debit
Amount = -100 - > Credit

Sure

add two calculation functions into the transfromer object

and use following scripts

begin
if (StrToFloat([F001])>0) then
result:=[F001]
else
result:='';
end;

begin
if (StrToFloat([F001])<0) then
result:=[F001]
else
result:='';
end;

Mike

Can you show me how that would be laid out? Would the 2 calculations be set in series, or parallel. Sorry, I am a little confused on how to structure this.

Assuming that your field is called amount

connect amount to two calculations in parallel
than connect first calculation to debit field and second to credit

=> Calculation 1 => debit
amount =>
=> Calculation 2 => credit

Mike