Script for text mining

[BriceRENOUF]

Dear all,

I want to do some Text mining and use the Levenshtein distance.

I have a text and want to analyse each word with all others.

From this table:

to this one:

I tried with some Generic load but it's not really clear...

Thanks for your help.

Brice

[Or · Accepted solution]

It looks like you're trying for a Cartesian join:

Load ID, Word From YourTable;

Join

Load Word as Comparison From YourTable;

[BriceRENOUF]

It works great!

Much easier than I thought...

Thanks a lot!