Needed decimal value in 99,999,999 format

[HemaV]

Hi All,

I need to perform sum(col1) group by col2 in oracle and that value i need to fetch as comma delimited like 99,999,999.

my source column col1 is decimal(22,5) and my target column is varchar2(10).

Is there any way to do this in transformer?

Thanks in Advance,

[ray.wurlod]

Only by writing your own function.

You can do it in a BASIC Transformer stage using the Fmt() function or the Oconv() function.

[BI-RMA]

It is possible by using a combination of stage-variables and loop-variables.

Code: Select all

svInput(Varchar(10)):AsInteger(Column))
svLen(Smallint):Len(AsInteger(Column))
svLoops(Smallint):Ceil(svLen/3.0) - dividend needs to be in float-format!

Loop While @ITERATION <= svLoops 

lvIndex(Smallint): If @ITERATION = 1 Then svInput [1,Mod(svlaenge,3)] Else If @ITERATION = 2 Then lvPart +1 Else lvPart +3
lvOutput: If @ITERATION = 1 and svLoops > @ITERATION Then svInput [1, lvPart]:"," Else If @ITERATION > 1 and svLoops > @ITERATION then lvOutput: svInput [ lvPart,3]:"," Else lvOutput: svInput [ lvPart,3]

Maybe this can be slightly optimized. Feel free.
Too complicated? See Ray's post!

[BI-RMA]

I forgot the filter-condition: @ITERATION = svLoops .

[HemaV]

Thanks for all the replies. I will try this solution.

[chulett]

I've always used FMT() for requirements like this.

[BI-RMA]

I've always used FMT() for requirements like this.

Yes, Craig. Ray mentioned that as well. But this was a requirement for a Parallel Job.

[chulett]

Which means you simply include it in a BASIC Transformer as Ray mentioned. And I mentioned it to reinforce Ray's mention.