cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
enteron Frequent Visitor
Frequent Visitor

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

<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>
2 ACCEPTED SOLUTIONS

Accepted Solutions
Super User
Super User

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

Hi,

 

You may refer to my solution here.

 

Hope this helps.

Highlighted
enteron Frequent Visitor
Frequent Visitor

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

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.

8 REPLIES 8
v-yulgu-msft Super Contributor
Super Contributor

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

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

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
enteron Frequent Visitor
Frequent Visitor

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

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 BerryBlue Berry
Red Apple, Blue Berry, Green BananaRed Apple, Blue Berry
Yellow Banana, Red Apple, Red BerryYellow Banana, Red Apple
Red Banana, Yellow Apple, Blue BerryBlue Berry

 

Thanks!

enteron Frequent Visitor
Frequent Visitor

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

Not sure but is this possible?

Super User
Super User

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

Hi,

 

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

 

Hope this helps.

 

Untitled.png

enteron Frequent Visitor
Frequent Visitor

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

Thanks in advance!!! Hope you could share it
Super User
Super User

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

Hi,

 

You may refer to my solution here.

 

Hope this helps.

Highlighted
enteron Frequent Visitor
Frequent Visitor

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

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.

Super User
Super User

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

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.

Helpful resources

Announcements
Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Power BI Helps Homeless and Trouble Youth

Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 283 members 2,607 guests
Please welcome our newest community members: