Requirement to transpose rows to columns but pivot column value has distinct values

[SJam2]

I have a requirement to transpose the data in a table as below:

Input:

Ticket_number object field_name field_value

1 Sales Birthdate 9999-12-31

1 Sales Birthdate 9999-12-03

1 Custom address India-hyd

1 Custom address India-chennai

Output:pipe delimited file

Ticket_number|object|birthdate|address

1|sales | 9999-12-31|

1|sales|9999-12-03|

1|Custom||India-hyd

1|Custom||India-chennai

Please help me with the solution on this

[Anonymous]

Hello,

Please feel free to let us know if this KB article helps for your case.

https://community.talend.com/s/article/Converting-rows-to-columns-Jewx3

Best regards

Sabrina