Skip to content

Request for UNPIVOT in Data Grid #1896

Open
@rkhapre

Description

Request for UNPIVOT in Data Grid
Currently we can do Pivot easily in Data Grid, it will be great if we can do unpivot also

Example
image

Currently we have 4 Columns : Quantity, Price, Amount, Profit. We need to Unpivot this and make it into Rows
User should be able to provide the Grouped Column Name and Grouped Column Value name like below

image

Please let me if this is something possible in current Data Grid.
I know we can do this at data ingestion level, but if you already have data in the table then its painful to re-ingest data again and then create reports and it is too much pressure to RAM to unpivot the data while ingesting. So much better is at client level using perspective library

Thanks
Ritesh

Metadata

Assignees

No one assigned

    Labels

    enhancementFeature requests or improvements

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions