Input data is as provided below:
Requirement: Likewise i have 150 columns and each column has multiple batches with different granularity. When am creating table chart the batches in each column shows like water fall model.
But my requirement is like showing Qlik Sense Table chart like input table as provided below.
i cannot create 150 table charts, which will impact performance of my app.
Please help me with data engineering that i need to do with these requirement..
Thanks in advance..help is highly appreciated.
Input data format:
| Group1 | Group2 | Group3 | Group4 | Group5 |
| | | | Batch1 | Batch1 |
| | | | Batch2 | |
| Batch1 | | | Batch3 | |
| Batch2 | | | Batch4 | |
| Batch3 | Batch1 | | Batch5 | |
| Batch4 | Batch2 | | Batch6 | |
| Batch5 | Batch3 | | Batch7 | |
| Batch6 | Batch4 | | Batch8 | |
| Batch7 | | | Batch9 | |
| Batch8 | | | Batch10 | |
| | | Batch1 | Batch11 | |
| | | Batch2 | Batch12 | |
| | | | Batch13 | |
| | | | Batch14 | |
Required output:
| Group1 | Group2 | Group3 | Group4 | Group5 |
| Batch1 | Batch1 | Batch1 | Batch1 | Batch1 |
| Batch2 | Batch2 | Batch2 | Batch2 | |
| Batch3 | Batch3 | | Batch3 | |
| Batch4 | Batch4 | | Batch4 | |
| Batch5 | | | Batch5 | |
| Batch6 | | | Batch6 | |
| Batch7 | | | Batch7 | |
| Batch8 | | | Batch8 | |
| | | | Batch9 | |
| | | | Batch10 | |
| | | | Batch11 | |
| | | | Batch12 | |
| | | | Batch13 | |
| | | | Batch14 | |
