Discussion board where members can get started with QlikView.
I have data as shown below
and i need to show like below,
Please suggest a way to create separate data set in the model or suggest a way to represent as required. PFA example data
Please check the attached
sorry missed attchment
LOAD distinct PSkey as RequiredFROMData\PSKEY.xlsx(ooxml, embedded labels, table is Sheet1);
Final:Directory;LOAD Skey,PSkey,ProftFROMData\PSKEY.xlsx(ooxml, embedded labels, table is Sheet1)Where Exists(Required,PSkey);
drop table Temp;
Skey PSkey Proft222 111 1000555 444 300777 666 300999 888 1000
Try to load your table this ways
Hope this helps.
Data:LOAD Skey, PSkey, ProftFROM[E:\C\Source\Test.xlsx](ooxml, embedded labels, table is Sheet1);
Inner Join(Data)New:LOAD Skey as PSkey, Proft as PProftResident DataWhere Len(PSkey) = 0;