Need help in extracting a field

[Anonymous]

I have a table name Device Attributes

I have 2 column in this table sName and sValue

When I brought this table in QlikView, below is the result. So sName and right side is their results. I need Location from sName as a separate field / column. (So I will be having a new column as Location and its result would be Abu Dhabi)...

sName	sValue
Brand	Fortinet, Inc.
Contact	Jim
Description	Dubai A20
Location	Abu Dhabi
MACAddress
MACAddressVendor	Fortinet Inc.
Model
Name
OID
OS
OSVersion
WAN Router	Yes

[Anonymous]

Thanks Jagan and Thanks everyone. Its working like a feather...