Hi Shong, thanks for that info. What about when you're counting rows on a foreign key? So for example, when I reach 'Payment No 5 of 5', I need it to return to Payment No. 1 of 1 when the foreign key changes and it all starts again, so my table will end up looking something like this:
PK | FK | PaymentDesc |
200001 | 462763 | Payment No. 1 of 5 |
200002 | 462763 | Payment No. 2 of 5 |
200003 | 462763 | Payment No. 3 of 5 |
200004 | 462763 | Payment No. 4 of 5 |
200005 | 462763 | Payment No. 5 of 5 |
200006 | 348111 | Payment No. 1 of 3 |
200007 | 348111 | Payment No. 2 of 3 |
200008 | 348111 | Payment No. 3 of 3 |
It's the 5s and 3s I'm trying to get. I need to know these numbers in advance. I have thought about using the tAggregateRow component, but I'm unsure how to incorporate the globalMap object.
Also, how do know what key to use to access a value in the globalMap? Is there a template that Talend uses? Or a way of displaying them all Enumeratively?
Thanks in advance,
Lee
ps - Apologies for the barrage of questions!