I have data in Table as ID 1 2 3 1 4 3 3 5 6 6 7 Now I want to have Output as repeatating records in one table & non-repeatating in another table Table 1 : Id 2 4 5 7 Table 2: ID 1 1 3 3 3 6 6 Thanks, Sushil

anirudh

• May 9th, 2017

You can use sort->aggregrator->count_rows->transformer stage write constraints row_count>1 to one file and row_count>1 to another output file

Neha

• Apr 7th, 2017

Seq File-> Aggregator (Count group by ID)->Transformer(Two output link , Use @Iteration1 and put @Iteration value in OpLnk2

Answer Question  Select Best Answer