Comparing a sentence to a list of words

[isciberras]

Hi everyone,

I have two separate tables one with a list of words and the other with a short sentence for example:

Words to check	Journal Description
error	2018 paperwork error
correction	error in posting caused by xyz
reversal	journal reversal in quarter 1
deferred	this is a standard journal
	this is a journal that is deferred

I would like to compare the table containing (Words to check) with the (Journal Description) table. Essentially I want to do some form of fuzzy matching with the whole sentence found in journal description with the keywords found in (Words to check) table.

Does anyone know if I can achieve this using Qlikview?

Thanks,
Isaac

[Gysbert_Wassenaar]

I'm not sure what you really want to do, but you could simply load all the sentences and add a listbox for that field and do a fuzzy search in the listbox. Type in *error* (including the starting and ending * wildcard characters) and you'll see the sentences filtered to show only those containing the word error.

[MarcoWedel · Accepted solution]

Hi,

one solution might be:

tabCheckWords:
LOAD [Words to check],
    AutoNumber([Words to check],'CheckWords') as %WordID
FROM [https://community.qlik.com/thread/311268] (html, codepage is 1252, embedded labels, table is @1)
Where Len(Trim([Words to check]));

tabJournDescript:
LOAD RecNo() as %JournDescID,
    [Journal Description]   
FROM [https://community.qlik.com/thread/311268] (html, codepage is 1252, embedded labels, table is @1)
Where Len(Trim([Journal Description]));

tabLink:
LOAD *
Where Exists (%WordID);
LOAD %JournDescID,
    AutoNumber(SubField([Journal Description],' '),'CheckWords') as %WordID
Resident tabJournDescript;

hope this helps

regards

Marco

[MarcoWedel]

see also:

Pair of words from sentence

hope this helps

regards

Marco

[isciberras]

Wow thank you that's exactly what I wanted to achieve and it worked perfectly! Thank you so much for your help

[MarcoWedel]

you're welcome

glad it helped

regards

Marco