View Full Version : Row Normaliser - Can it handle more complex situations ?

01-23-2006, 11:21 AM
(Edited: Original message by Surenm, put in plain format)

I tried using the Row Normaliser but with limited success. I have a real life scenario here. If the Row Normaliser can support it, that will be great (unless I am missing something).

EmplId OfferId TotalAllotted Allotment1 Date1 Allotment2 Date2 .. ...
1234 XX 75 25 aaa 50 bbb ..
1234 YY 100 50 ccc 50 ddd ..

I would like to use the Row Normaliser to give me a result as follows:

EmplId OfferId Allotment Date
1234 XX 25 aaa
1234 XX 50 bbb
1234 YY 50 ccc
1234 YY 50 ddd

01-23-2006, 11:29 AM
Yes, it can handle the more complex situations.

Please see page 79 of the Spoon manual.
It's almost exactly the example you have given.

I know it's a bit ackward to enter, but haven't figured out a better way to do it.
Any suggestions are welcome.

All the best,


01-23-2006, 08:21 PM
Thank you, Matt for pointing me to the manual. I should have done it myself.

01-23-2006, 10:06 PM
No problem, the range of subjects becomes wider every day.
Although this in itself is a good thing, I guess in the long run it becomes harder to find the functionality that you want.

My dream is to integrate a help system in auto-generated dialog boxes so that you can get context sensitive help.
Both on a field level as on a step level.
Mmm, better put that on the 3.0 to-do list ;-)