In my job i want to pivot rows values to columns, exampe :
C1 | C2 | C3
M | D | F
M | A | J
Result
C1 | C2 | F | J
M | D | 1 | 0
M | A | 0
| 1
i used tPivotToColumns Delimited, but it always create a file as an output for my result, is there any other component that can help resolving my case ?
I'm afraid there isn't another version of this component to output as rows within the job. This could actually be a nice example of an idea to try out our component toolkit .....but I get that you want a solution to your problem here.
You have a couple of options. The first (and easiest) would be to carry on writing to a file and then read that file back in to the job. Not ideal, but it would be a quick solution this. Another way would be to write a routine to do this in Java. This would obviously depend upon your ability to write code in Java. You may be able to find example code online which you can borrow to help you here.
