Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Using fields as headers

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. 

Labels (3)
2 Replies
TRF
Champion II
Champion II

Can you give some details regarding the transformation rules to be applied?

Anonymous
Not applicable
Author

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.