hi,
please help in solving this problem....
1.The input file contains the following records,
column1, column2 , column3 , column4
1 , _ , _ , _
_ , 2 , _ , _
_ , _, 3 , _
_ , _ , _ , 4
*here underscore( _ ) indicates null value..
2.The output file must contain all the values of input file in a single row as shown below,
column1, column2 , column3 , column4
1 , 2 , 3 , 4
To achieve this what is the condition that i have to implement in transformer or whether i have write a stage variable?
Thanks in advance and greatful to them ,if any one help me in solving this problem
converting multiple rows to single row!!
Moderators: chulett, rschirm, roy