Skip to Content
0
Former Member
Jan 13, 2012 at 07:03 PM

Groupby condition in output table

30 Views

Hello,

I have to implement a groupby condition and remove the duplicate records from output table. I could do that in sql and my query looks like this:

select col1,col2,col3, COUNT(col3) from TARGET_TABLE group by col1, col2, col3 having count(col3) >=2

I get 99 records when i run this query in sql. I need that 99 records to go in as error table output in DI and remaining records to TARGET_TABLE.

Where can i insert the sql and get two outputs (final output) and (error table).

Appreciate your ideas.

Arun