topic Re: how to transform rows to column in Talend Studio

how to transform rows to column

Anonymous — Sat, 16 Nov 2024 03:09:51 GMT

Hello everyone,

I have an issue at hand i am trying to transpose rows to columns this is what i have

PROFILE;FIELD;EDITABLE;READABLE
AA;BA;TRUE;FALSE
AA;BB;TRUE;TRUE
AB;BA;FALSE;TRUE
AB;BB;TRUE;FALSE
 
I want to achieve this

	AA	AA	AB	AB
	EDITABLE	READABLE	EDITABLE	READABLE
BA	TRUE	FALSE	FALSE	TRUE
BB	TRUE	TRUE	TRUE	FALSE

can anyone help please??

Re: how to transform rows to column

Anonymous — Thu, 27 Feb 2020 01:12:42 GMT

Utilisé le composant tsplitRow

Re: how to transform rows to column

Anonymous — Thu, 27 Feb 2020 04:18:40 GMT

Merci pour l'aide. j'ai pu trouver un moyen avec tpivottocolumndelimited

Re: how to transform rows to column

Anonymous — Thu, 27 Feb 2020 16:49:46 GMT

You can use the tNormalize or tDenormalize.

Re: how to transform rows to column

Anonymous — Thu, 27 Feb 2020 16:52:03 GMT

You can use the tNormalize or tDenormalize.
they allow you to transform row to column or column to row.
Otherwise if you use TOS , get the tUnpivotrow on exchange.