https://community.qlik.com/t5/Connectivity-Data-Prep/Script-for-text-mining/m-p/2052552#M12113 <P>Dear all,</P> <P>I want to do some Text mining and use the Levenshtein distance.</P> <P>I have a text and want to analyse each word with all others.</P> <P>From this table:</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="text_mining_from.png" style="width: 113px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/103378iC2B345A08A75C927/image-dimensions/113x102?v=v2" width="113" height="102" role="button" title="text_mining_from.png" alt="text_mining_from.png" /></span></P> <P>to this one:</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="text_mining_to.png" style="width: 178px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/103381iD8E1BA6E4A2C0DC6/image-dimensions/178x537?v=v2" width="178" height="537" role="button" title="text_mining_to.png" alt="text_mining_to.png" /></span></P> <P>I tried with some Generic load but it's not really clear...</P> <P>Thanks for your help.</P> <P>Brice</P> Thu, 23 Mar 2023 14:33:33 GMT BriceRENOUF 2023-03-23T14:33:33Z https://community.qlik.com/t5/Connectivity-Data-Prep/Script-for-text-mining/m-p/2052552#M12113 <P>Dear all,</P> <P>I want to do some Text mining and use the Levenshtein distance.</P> <P>I have a text and want to analyse each word with all others.</P> <P>From this table:</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="text_mining_from.png" style="width: 113px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/103378iC2B345A08A75C927/image-dimensions/113x102?v=v2" width="113" height="102" role="button" title="text_mining_from.png" alt="text_mining_from.png" /></span></P> <P>to this one:</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="text_mining_to.png" style="width: 178px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/103381iD8E1BA6E4A2C0DC6/image-dimensions/178x537?v=v2" width="178" height="537" role="button" title="text_mining_to.png" alt="text_mining_to.png" /></span></P> <P>I tried with some Generic load but it's not really clear...</P> <P>Thanks for your help.</P> <P>Brice</P> Thu, 23 Mar 2023 14:33:33 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/Script-for-text-mining/m-p/2052552#M12113 BriceRENOUF 2023-03-23T14:33:33Z https://community.qlik.com/t5/Connectivity-Data-Prep/Script-for-text-mining/m-p/2052567#M12114 <P>It looks like you're trying for a Cartesian join:</P> <P>Load ID, Word From YourTable;</P> <P>Join</P> <P>Load Word as Comparison From YourTable;</P> Thu, 23 Mar 2023 14:55:25 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/Script-for-text-mining/m-p/2052567#M12114 Or 2023-03-23T14:55:25Z https://community.qlik.com/t5/Connectivity-Data-Prep/Script-for-text-mining/m-p/2052570#M12115 <P>It works great!</P> <P>Much easier than I thought...</P> <P>Thanks a lot!</P> Thu, 23 Mar 2023 14:58:35 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/Script-for-text-mining/m-p/2052570#M12115 BriceRENOUF 2023-03-23T14:58:35Z