Group by a column based on fuzzy match

[umashankarus]

Hi Experts

I have a table with several data columns.

And one of the field is a string type. (This field is feed from a data source where free form description allowed)

SOURCE_TABLE:

F1, F2, F3

ABC , 100, $20000

abc Inc., 220, $25000

Abc Plastics, 230, $23000

3M, 100, 12000

3M Care, 175, 6500

And the real data contains 100s of variations of F1

In this example, I want the resultant table with F1 and F3, grouped by F1

RESULTANT_TABLE:

F1, F2

ABC, $68000

3M, $18500

Can the resultant F1 be stored in a mapping table

and

add resultant F1 as a column to the source table through apply map based on 'fuzzy' match ?

If so, can you pl share sample script ?

Also pl suggest other options to achieve this ?

Thanks,

Umashankar

[ahaahaaha]

Excellent collection of links on the subject provided Marco below  . I do not know the content of your task as a whole. In my opinion only the following should be considered.

Any language is redundant. Restore the meaning of the text by fragments of words and even individual words possible.

However, when it comes to the key fields, it seems to me, the use of fuzzy generalization method is not correct.

Regards,

Andrey

[umashankarus]

Thanks Marco

[umashankarus]

Thanks Andrey

[MarcoWedel]

you're welcome

regards

Marco

Qlik Community Tip: Marking Replies as Correct or Helpful