Wildcard search need help urgent

[#1]

Hi,

I have a huge  list of entries in excel for example

MatchKey       Category

*qwerty* critical

*asdfg*   medium

*organic* high

*metal*   low

*sql*      medium

I need to match the matchkey with the available list of hostnames.

for example if my hostname is

Hostname

qwertykeyboard

asdfgcfghkodddgdfgfg

metalicboard

sqlquery

organicapple

my output should be like if i select any hostname the category should be reflected

if  I select qwertykeyboard the Cateogry critical should be reflecting.

Thanks in advance

[#2]

Hi thirurumala

Please find the sample sheet having hostname nd repective maptable fields to give the accurate result.

Thanks in advance

[swuehl]

Mehare Nigar wrote:

This is not working.

For selected hostname I need respective category.

This is not working is not a good issue description.

Have you even had a look at the sample I've attached?

What's wrong with the Categories that have been mapped to Hostname?