topic Re: Replacing keywords with synonymns in QlikView

Replacing keywords with synonymns

shyamcharan — Thu, 16 Jul 2015 03:01:38 GMT

Hi Experts,

I have a requirement where I should allow users to let search with various Synonyms words but still get the closest match in the result.

For example:

Synonym Table:

Keyword, Synonym

Sydn, Sydney

Syd, Sydney

Sydney, Syd

Syd, Syd

Trn, Train

Tr, Trn

Tran, Trn

Tran, Train

T, Train

St, Station

Stn, Station

St, St

Stn, Stn

Plt, Platform

Pltfm, Platform

Platform, Plat

Actual Table:

Column1

Sydney Train Station Platform

I need something like a column that will created in the Actual Table and called as Column1Synonym and values should be like as below

Actual Table:(With synonym column)

Column1, Column1Synonym

Sydney Train Station Platform, Sydn Sydney Syd Trn Train Tr Tran Trn T St Station Stn Plt Platform Pltfm Plat

Is this acheivable by any function like Applymap?

Or is there a functionality that I can build that could be called as Data Dictionary so that this can be used for searching?

Thanks heaps in advance.

Regards,

Shyam.

Re: Replacing keywords with synonymns

Siva_Sankar — Thu, 16 Jul 2015 03:23:00 GMT

Refer Displaying the search string of Search box in a Text object and Is Search with Synonym Words possible?

Re: Replacing keywords with synonymns

shyamcharan — Thu, 16 Jul 2015 03:41:18 GMT

Hi Shankarece,

Thanks for tagging in my own old posts.

But this requirement is completely different.

This time I need a column that is created using the Actual Column data and the Synonym words.

Sorry if I misunderstood your reply.

Thanks heaps in advance.

Regards,

Shyam.

Re: Replacing keywords with synonymns

robert_mika — Thu, 16 Jul 2015 03:55:12 GMT

This time I need a column that is created using the Actual Column

Could you post an example how this column should look like?

Re: Replacing keywords with synonymns

shyamcharan — Thu, 16 Jul 2015 04:38:51 GMT

Hi Robert,

Thanks for the response. I have put an example in my first post and the same I am putting down below for reference.

Actual Table:(With synonym column)

Column1, Column1Synonym

Sydney Train Station Platform, Sydn Sydney Syd Trn Train Tr Tran Trn T St Station Stn Plt Platform Pltfm Plat

The Synonyms are from the Synonym table as said in my first post.

Regards,

Shyam.