Calculate duplicate values on the basis of dimension values

[ruma_barman]

Hello All,

I want to calculate each server occurance from the below field,this can be duplicated as well,Check the output

Load * Inline

[
Servers                                                 ,Count

LinuxServer;NetworkDevices                 ,2
NetworkDevices;Other                           ,4
StorageDevices;WindowsServer;Other ,5
WindowsServer                                      ,6
Other                                                      ,10
];

Expected:

Servers	Count
Linux Server	2
Network Devices	6
Storage Devices	5
Windows Server	11
Other	19

Thanks in advance,

Ruma

[Chanty4u]

Use this calculated dimension

=SubField(Servers, ';', IterNo())

[Anil_Babu_Samineni · Accepted solution]

@ruma_barman Perhaps this?

QC_M246141:
Load SubField(Servers, ';') as Servers, Count Inline

[
Servers ,Count

LinuxServer;NetworkDevices ,2
NetworkDevices;Other ,4
StorageDevices;WindowsServer;Other ,5
WindowsServer ,6
Other ,10
];

Final:
NoConcatenate
Load Servers, Sum(Count) as Count Resident QC_M246141 Group By Servers;

Drop Table QC_M246141;