Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
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
Thanks,
Ganesh
Please check the attached
sorry missed attchment
Code used:
Temp:
LOAD distinct PSkey as Required
FROM
Data\PSKEY.xlsx
(ooxml, embedded labels, table is Sheet1);
Final:
Directory;
LOAD Skey,
PSkey,
Proft
FROM
Data\PSKEY.xlsx
(ooxml, embedded labels, table is Sheet1)
Where Exists(Required,PSkey);
drop table Temp;
OUTPUT:
Skey PSkey Proft
222 111 1000
555 444 300
777 666 300
999 888 1000
Hi,
Try to load your table this ways
Hope this helps.
Data:
LOAD Skey,
PSkey,
Proft
FROM
[E:\C\Source\Test.xlsx]
(ooxml, embedded labels, table is Sheet1);
Inner Join(Data)
New:
LOAD Skey as PSkey,
Proft as PProft
Resident Data
Where Len(PSkey) = 0;
Regards
Anand