Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
@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;
Use this calculated dimension
=SubField(Servers, ';', IterNo())
@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;