ravula sudheer

 Profile Answers by ravula sudheer Questions by ravula sudheer

• Oct 18th, 2008

 

To avoid the duplicates use rollup component.
Rollup component avoidS the duplicates and produces actual results.

biyyanimv

 Profile Answers by biyyanimv Questions by biyyanimv

• Feb 2nd, 2009

 

Use dedup sort to avoid duplicates

Mihira Barik

 Profile Answers by Mihira Barik Questions by Mihira Barik

• Nov 4th, 2009

 

We can avoid duplicate by using "key_change" method of the rollup component.
The code will be like below.

out :: key_change(prev,curr)=
begin out :: cur != prev ; end out :: rollup(in) = begin out :: in ; end

karti

• Aug 31st, 2020

 

it works if input is like below only
i/p
1
1
2
2
2
3
3

Amruta

• Jan 9th, 2021

 

What I am thinking is to sort the data 1st and then use scan component--Give key and define temp variable which will generate sequence per group.....in output select seq number as 1...This will reduce duplicates and give distinct record at output