iam new to datastage and am in learning stage. please let me know how to break coloumns to get subtotals in other row.
sample ip
id|colA|colB
1|x|z
2|y|t
1|a|b
3|c|d
desired output
1|x|z
1|a|b
1|2|
2|y|t
2|1|
3|c|d
3|1|
iam just practicing this scenario, after making derivation am getting like below output
id|colA|colB
1|a|b|
1|x|z**BREAK**1|2
2|y|t**BREAK**2|1
3|c|d**BREAK**3|1
now how to break columns to get subtotals
i used unix command in sequential stage filter option its not working properly.
and how can it take new row(sub total value) without assigning.
please let me guide.
Thanks in advance
![Confused :?](./images/smilies/icon_confused.gif)