Data Manuplation

[amnac]

I have this input data:

and following output is required:

I want to check every location get all the Bandwidths on it then finding the vale corresponding to Name with Bandwidths not equal to 1Gbps like 400MBPS and 200 MBPS in oue example

Thanks

[IraWatt]

Hey @amnac,

I have started this off but I don't quite follow the logic:

I used regex to get the number in the name. Then I said if its 1Gbps its goes to true or if the number in the name is contained within the bandwidth its true. Could you help explain what else is missing?

[binuacs]

@amnac I don't understand the logic of 1gbps the rest of the records can be extracted using the below logic