Problem with Pivot Stage
Posted: Thu Nov 03, 2005 4:38 pm
Hello Everybody,
I used a Pivot stage to do horizontal pivotting
I connected a Transformer stage to filter those pivotted record with null values
Not(IsNull(filed name))
I am getting all the rows
I tried using trim to remove any space
Not(IsNull(Trim(filed name)))
and even then it was doing the same
So I loaded the output of the pivot stage to a Sequential file and then passed this through the Transformer for filtering
I got the right output
Can somebody explain me this?
Thank you
Regards,
Kishan
I used a Pivot stage to do horizontal pivotting
I connected a Transformer stage to filter those pivotted record with null values
Not(IsNull(filed name))
I am getting all the rows
I tried using trim to remove any space
Not(IsNull(Trim(filed name)))
and even then it was doing the same
So I loaded the output of the pivot stage to a Sequential file and then passed this through the Transformer for filtering
I got the right output
Can somebody explain me this?
Thank you
Regards,
Kishan