adding sub sequence using stages

dsisbank · Post by **dsisbank** » Thu Dec 07, 2006 3:22 am

Hi,
I am junior developer and have problem.I have source data like above.Credit_id is increasing automatically

credit_id proposal_id
1 1
2 1
3 1
4 2
5 2
and i want to put this data to target like this

credit_id proposal_id credit_index
1 1 1
2 1 2
3 1 3
4 2 1
5 2 2

how can i do?
thanks for your helps

kumar_s · Post by **kumar_s** » Thu Dec 07, 2006 3:27 am

Hi Welcome aboard!!! :D
You can simply use sort stage and sort based on Proposal_id and include a column to detect the change in Key column option to have the serial number to be generated. Optionally you can use transformer to detect the change in previous row to the current row.

dsisbank · Post by **dsisbank** » Thu Dec 07, 2006 3:48 am

thanks for your helping
but how can i detect the change in previous row to the current row in transformer

ray.wurlod · Post by **ray.wurlod** » Thu Dec 07, 2006 5:41 am

The Sort stage can generate two extra columns (key change and cluster key change). You need the first of these. Pass it into your Transformer stage and use it to reset your counter (a stage variable, probably) to 1 when the key value changes.