Hi Guys,
Need help on merging data. i have two columns ( first and second) which has the same value but instead of showing two different lines, i need to show to only one value for these columns while the 3rd and 4th column remains as individual rows. Please let me know how to resolve this.
StorageArray_serialNumber TotalPorts LinkStatusType StorageArray_Port_topology
92213279 16 8 Link Failure
92213279 16 8 LinkUp(F_Port Connected)
My desired output.
StorageArray_serialNumber TotalPorts StorageArray_Port_topology LinkStatusType
Link Failure 8
92213279 16 -----------------------------------------------------------
LinkUp(F_Port Connected) 8
----------------------------------------------------------------
Try something like this
your current search with first output | stats list(*) as * by StorageArray_serialNumber, TotalPorts