Keyword Searching between 2 Different Tables

[Pulkit_Thukral]

Hi All,

i am creating a logic for keyword searching for the below scenario:

i have 2 different excels :

1st excel has Keyword

2nd excel has 'id' written in the description field so we have to do wildmatch for searching.

Example:

1st Excel :

Keyword

ABC

DEF

XYZ

2nd Excel:

Ticket      State      --------      Description

1               new      --------      ORA:ABC-daskjasdas

2               closed   --------      SRV:DEF-sadra

My Output should be joining both the tables based on 1st excel field(left join)

Output:

Keyword        Ticket      State      --------      Description

ABC            1               new      --------      ORA:ABC-daskjasdas

DEF            2               closed   --------      SRV:DEF-sadra

as i found keyword written in description field for these 2 keywords only.

[sunny_talwar]

I think this is how I would do it as well. No need to do a heavy cross join as kushal‌ has already pointed out.

[qlikview979]

Hi Nag,

I got It . in your Expression

where WildMatch(Description, '*'& Keyword &'*' );

after Keyword  How it will work "*"

Regards,

Mahesh.

[Kushal_Chawda]

Yeah.. should go with tresesco‌ suggestion.