DSXchange

Some how I get this error only when schedule the job for current day and not if I use any future date. Is it still not a bug then?

maybe worth trying with

If IsNull(string) Then SetNull() Else StringToDecimal(trimLeadingTrailing(string))


sometimes it attaches a extra space at the start

maybe worth trying with

If IsNull(string) Then SetNull() Else StringToDecimal(trimLeadingTrailing(string))


sometimes it attaches a extra space at the start[/b]

maybe 'yyyy-mm-dd' is not your default DataStage date format? Try with 'dd-mmm-yyyy'

By default the lookup gets the results from the first match found and for subsequent ones gives the warning.

Go to constraint tab on lookup stage and then select the reference link from 'Multiple rows returned from link' drop box - this way it will get the results with all matches with no warnings.

How do you arrive at 'T' in output & and what is criteria to merge... Are sets of 2 rows to be merged into one ?

use join

or

in the look up stage --> goto constraints and select the link name in "Multiple rows return from link" drop box.

Trim(Col1,"0","L") will give 20.00 for 00000000020.00, but for 0000000000.15 it will give .15. i hope that is not required if the target field is of currency format... plz correct me if i am wrong. try with : (if col1 <1 then '0' else ''):Trim(DecimaltoString(col1),"0",...

Trim(Col1,"0","L") will give 20.00 for 00000000020.00, but for 0000000000.15 it will give .15. i hope that is not required if the target field is of currency format...

plz correct me if i am wrong.

Thanks - Sajal

Trim(Col1,"0","L") will give 20.00 for 00000000020.00, but for 0000000000.15 it will give .15. i hope that is not required if the target field is of currency format...

plz correct me if i am wrong.

Thanks - Sajal