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

SJam2 — Fri, 15 Nov 2024 21:19:33 GMT

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

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

Anonymous — Fri, 20 Oct 2023 03:48:27 GMT

Hello,

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

Best regards

Sabrina