How to get subtotals

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
jastichoudaryuu
Participant
Posts: 12
Joined: Mon Jan 31, 2011 7:19 am

subtotals

Post by jastichoudaryuu »

how to break columns to get subtotals.
Last edited by jastichoudaryuu on Wed Jun 01, 2011 1:36 am, edited 1 time in total.
anilkumar
jastichoudaryuu
Participant
Posts: 12
Joined: Mon Jan 31, 2011 7:19 am

how to break that column mentioned in calculating subtotal

Post by jastichoudaryuu »

Hi,
iam new to datastage and am in learning stage. please let me know how to break coloumns to get subtotals in other row.
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.
Thanks in advance :?
anilkumar
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

[split from this topic]

First let's start by not hijacking someone else's old post and start your own. Post a link to the other post if you think it will really be helpful, but we need your particulars - version, O/S, etc - and an example of your issue/question in order to help you. Also, that way you have control over the fate of the topic and can mark it resolved so we get there.

So, I've made a guess in your first post as to O/S, version, etc - edit it if I've got it wrong. Also can you post an example of your specific issue, sample input and desired output?
-craig

"You can never have too many knives" -- Logan Nine Fingers
jastichoudaryuu
Participant
Posts: 12
Joined: Mon Jan 31, 2011 7:19 am

Post by jastichoudaryuu »

thanks chullet for response i will post new link
anilkumar
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

I meant next time as I'd already done the dirty work for you here. Ah well, that works too. If people want to help, please respond there not here.

Thanks.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply