transpose Row to Column but not same as tpivottocolumns

krishu — Sat, 16 Nov 2024 00:00:53 GMT

Hi Team

I have a requirement, where i need to transpose rows to columns but its not similar to using tpivot component. I tried using tpivot, normalize, tdenormalize but nothing worked! Providing the sample input and expected output.

Attached the screenshot and also sample data below:

Sample Input Data

--------------------------------------

|Prod_Type |Prod_No | Prod_Price|

--------------------------------------

| 1 |123456 | 24.5 |

| 1 |234567 | 234.6 |

| 1 |345678 | 10 |

| 1 |2412421 | 1000 |

| 1 |7689657 | 345 |

| 1 |456891 | 635.61 |

| 1 |6578709 | 450.11 |

| 1 |999876 | 222 |

Expected Out:

--------------------------------------------------------------------------------------------------------------------------------------------------

--------------------------------------------------------------------------------------------------------------------------------------------------

1 | 123456 | 24.5 | 234567 | 234.6 |345678 | 10 | 2412421 | 1000 | 7689657 | 345

2 | 456891 | 635.61 | 6578709 | 450.11 | 999876 | 222 | | | |

Any ideas or approaches to achieve this!

Thanks & Regards

Krishu

Re: transpose Row to Column but not same as tpivottocolumns

Anonymous — Mon, 28 Jun 2021 07:33:45 GMT

Hello,

It seems you are trying to group Prod_Type with the same type. Please have a look at tSortRow and tUniqRow components to achieve your goal.

Best regards

Sabrina

Re: transpose Row to Column but not same as tpivottocolumns

krishu — Mon, 28 Jun 2021 17:56:20 GMT

Hi Sabrina

Thanks for the reply!. Am not sure how tSortRow and tUniqRow helps to achieve this!?

Regards

Krishu

topic Re: transpose Row to Column but not same as tpivottocolumns in Talend Studio

transpose Row to Column but not same as tpivottocolumns

Re: transpose Row to Column but not same as tpivottocolumns

Re: transpose Row to Column but not same as tpivottocolumns