I have requirement in qlik sense to group the table data by a column values (A, B, C, D) and add new rows for missing values in the group.
Ex: My table data is in below format
Id
date
incidence
material
thickness
1
12/7/2021
A
material1
17
1
12/7/2021
C
material2
26
1
12/7/2021
D
material3
35
1
12/7/2021
B
material4
44
1
12/7/2021
C
material5
8
In the above table , for the Column Id 1 , after grouping the incidence column by A,B,C, D ; one more C is left for which new group has to be created with A, B, D and other field values for these new rows A, B, D should be empty
Expected output table :
Id
date
incidence
material
thickness
1
12/7/2021
A
material1
17
B
material4
44
C
material2
26
D
material3
35
A
B
C
material5
8
D
I tried by creating an inline table for Incidence column
IncidenceTable: Load * Inline [ Incidence A B C D];
and right join this IncidenceTable with my actual table to group the table data by Incidence column values A,B,C,D. But this is creating 4 new rows for each row in actual table. but requirement is to add new rows for only missing values in the Group (A, B, C , D).
Any help is appreciated or please let me know if any extension is present to show the table data in this format
