Skip to Content
0
Former Member
Nov 27, 2009 at 09:17 AM

Update/Overwrite in same Transformation on same Key Figure

41 Views

Hi all.

I got DSO with procent keyy figure (Z_PRCNT).

I need do summarize the key figure in transformation if I'm getting it with the same key, BUT if Z_PRCNT is already = 100 or i'm geeting above 100 on summation, I need to post exact 100 as result.

Example as illustration

data source:

KEY______PROCENTS

011______30

011______80

012______10

012______20

013______150

must get results in DSO as

ZKEY______Z_PRCNT

011______100

012______30

013______100

thanx in advance