Power Query: List the words contained in a cell that occur in another query

[enteron]

<p>Is there a way I could get another column to display a list of items that occur in another query from a specific column?</p>
<p>&nbsp;</p>
<p>Example:</p>
<p>TextList</p>
<table>
<tbody>
<tr>
<td>This garden has an apple tree.</td>
<td>Apple</td>
</tr>
<tr>
<td>The basket has apples and bananas.</td>
<td>Apples, Bananas</td>
</tr>
<tr>
<td>The banana cake has corn.</td>
<td>Banana, Corn</td>
</tr>
<tr>
<td>The fox jumped over the dog.</td>
<td>Null</td>
</tr>
</tbody>
</table>
<p>&nbsp;</p>
<p>&nbsp;</p>
<p>Query to search the word/s from:</p>
<p>&nbsp;</p>
<p>Fruits</p>
<table>
<tbody>
<tr>
<td>apples</td>
</tr>
<tr>
<td>bananas</td>
</tr>
<tr>
<td>corn</td>
</tr>
</tbody>
</table>
<p>&nbsp;</p>
<p>&nbsp;</p>
<p>&nbsp;</p>
<p>Appreciate the help!</p>

[Ashish_Mathur · Accepted solution]

Hi,

You may refer to my solution here.

Hope this helps.

[v-yulgu-msft]

Hi @enteron,

Please share sample data and show us desired output to make your requirement more clear.

How to Get Your Question Answered Quickly

Regards,

Yuliana Gu

[enteron]

Sorry about that didn't realize the tables didn't show up as intended. 

Phrases/Words to Match

Yellow Banana

Red Apple

Blue Berry

Text StringList/Output

Green Banana, Yellow Apple, Blue Berry	Blue Berry
Red Apple, Blue Berry, Green Banana	Red Apple, Blue Berry
Yellow Banana, Red Apple, Red Berry	Yellow Banana, Red Apple
Red Banana, Yellow Apple, Blue Berry	Blue Berry

Thanks!

[enteron]

Not sure but is this possible?

[Ashish_Mathur]

Hi,

This is possible.  Here is the result i got.  I will share my solution in a couple of days.

Hope this helps.

[enteron]

Thanks in advance!!! Hope you could share it

[Ashish_Mathur · Accepted solution]

Hi,

You may refer to my solution here.

Hope this helps.

[enteron · Accepted solution]

Thanks for the input Ashish! I'm wondering though if it's also possible to extract certain phrases and get a table/list output if the source cell contains a sentence and there are no delimiters.

[Ashish_Mathur]

You are welcone.  If my reply helpd, please mark it as Answer.  I doublt if i can help you with your second question.  Share the data and show the expected result.