How to convert multiple rows into single row in datastage
4. In remove dup stage enable retain last option and mapped output to next stage. 5. now take another Trnsfrm define 3 col in output tab in trnfrm and use field function, lyk field(stage var,,,1) for city1 thn