Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have a situation that I can't imagine how to solve using Talend Studio. Yes, I'm a beginner (sorry if the problem has an obvious solution but I can't find it.
I have a file like this:
CAMPO1 CAMPO2 CAMPO3 CAMPO4
C1Valor1 C2Valor1 C3Valor1 C4Valor1
C1Valor1 C2Valor1 C3Valor2 C4Valor2
C1Valor1 C2Valor2 C3Valor1 C4Valor3
C1Valor1 C2Valor2 C3Valor2 C4Valor4
C1Valor2 C2Valor3 C3Valor1 C4Valor5
C1Valor2 C2Valor3 C3Valor2 C4Valor6
C1Valor2 C2Valor3 C3Valor3 C4Valor7
C1ValorN C2ValorN C3ValorN C4ValorN
I need an excel output whith this structure:
C1Valor1 |
|||
|
C2Valor1 |
C2Valor2 |
C2Valor3 |
C3Valor1 |
C4Valor1 |
C4Valor2 |
|
C3Valor2 |
C4Valor3 |
C4Valor4 |
|
C3Valor3 |
C4Valor5 |
C4Valor6 |
C4Valor7 |
|
|
||
C1ValorN |
|||
|
C2ValorN |
|
|
C3ValorN |
C4valorN |
|
|
|
|
|
|
I can't find nothing specific to do this in Talend.
Could someone give me clues about it.
Can you give some details regarding the transformation rules to be applied?
There are no tranformations, the fields in the CAMPO2 of the original must be change to headers of the exit.
You have to distribute all the values from CAMPO4 maching the conditions of the fields in CAMPO2 and CAMPO3 and grouping everything by the value of CAMPO1.