DSXchange

Hi ,
Please help me how to implement this logic in DS.

soure is coming like this

code1 val1 group1
____________________________________
1 p abc
0 p abc

1 a fpg
0 a fpg

------------------------------------------------


out put should be like this

code1_val1 group1
------------------------------
1p0p abc
1a0a fpg

Thanks in advance,
Chris

code1 val1 group1
____________________________________
1 p abc
0 p abc

1 a fpg
0 a fpg

------------------------------------------------


Before getting to design.. i wanted to know .. How many times can a Group appear in a file. i.e., say do u have any requirement that "abc" appears only twice or at a max. for N times.

regards.
Kiran.

Welcome aboard
Sort your incoming data by val1.
Use two stage variables to do the group changing dance, say cond and prevVal. They should be in the same order as i specified. cond first and prevVal second.

after doing that your output data will look like
pass the output through an aggregator, group on the code1_val1 and group1 and specify the "Last" option for middle column
that will give you your desired output.
Regards,

Hi,
In my requirement "abc" appears only twice .

DSkkk wrote:code1 val1 group1
____________________________________
1 p abc
0 p abc

1 a fpg
0 a fpg

------------------------------------------------


Before getting to design.. i wanted to know .. How many times can a Group appear in a file. i.e., say do u have any requirement that "abc" appears only twice or at a max. for N times.

regards.
Kiran.

Try to go through my logic. In that, it doesnt matter how many times abc or for that matter any other value exist. All you need is to be sorted by val1 and the design will take care of the rest.

[quote="DSguru2B"]Try to go through my logic. In that, it doesnt matter how many times abc or for that matter any other value exist. All you need is to be sorted by val1 and the design will take care of the rest.[/quote

That will definitely work, but if you know for sure that it appears twice, I would always go for a self join query. I always prefer finishing such stuff at the database end itself.

HI

use this select statement u can get as u required

select max(code1) || max(var1) ||min(code1)||min(var1),group1 from abc group by group1

Thanks

Dharma

chrisjones wrote:Hi ,
Please help me how to implement this logic in DS.

soure is coming like this

code1 val1 group1
____________________________________
1 p abc
0 p abc

1 a fpg
0 a fpg

------------------------------------------------


out put should be like this

code1_val1 group1
------------------------------
1p0p abc
1a0a fpg

Thanks in advance,
Chris

DSguru2B has a good solution for you to use.