topic Re: Using fields as headers in Talend Studio

Using fields as headers

Anonymous — Sat, 16 Nov 2024 05:36:09 GMT

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.

Re: Using fields as headers

TRF — Thu, 13 Jun 2019 11:09:40 GMT

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

Re: Using fields as headers

Anonymous — Thu, 13 Jun 2019 12:07:50 GMT

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.