DSXchange

Hi,

I have i/p as

id date gp code amt
1 1992-01-01 US abc 123
1 1992-01-01 US abc 124
1 1992-02-01 US abc 234
1 1992-03-01 US abc 245

Expected o/p

id gp code jan feb march april june july aug sept oct nov dec
1 US abc 247 234 245


i used pivot stage and type as vertical pivot . group by by id,gp,code and pivot column amt, array size 12

i am getting o/p as
id gp code jan feb march april june july aug sept oct nov dec
1 US abc 123 124 234

not sure where i am going wrong and also iam sending sorted data to pivot stage . Any suggestions please.

Thanks

Look at your data. You have two entries for January. Use a Remove Duplicates stage to keep only the last in each group, if that's what you need.

Thanks ray for quick response.

ya there are two entries for jan and i need both the records to be aggregated as single record . i tried using agrregator stage before pivot stage. But the job just hangs and is not proceeding further after aggregator stage.

Did you specify "Sort" mode for the Aggregator stage, since your data are already sorted by the grouping key?

yes i did. its going out of aggregator stage but not comming out of pivot. Its hanging there.

How much data are we talking about? How long did you wait before you declared that it was hung?

its not huge data. I am testing on only 12 rows, I have waited for 20 mints.

Any alternate solution/suggestions/ideas to get my expected o/p.

For starters, don't push. Your last two posts were at 10:48pm and 1:22am my time. DSXchange is an all volunteer site whose members post if and when they can, at the same time being under no obligation to do so.

If you effect the pivot using a Transformer stage, does it still hang?

How, precisely, are you configuring the PXPivot stage?