I have this two sheets, one for news, one for opportunities. What i would like to reach is to have in sheet opportunies all the news of a single company.
The problem here is that there are news with two or more companies associated. So if I query the split column of the opportunities associated with the name of the opportunity, the result of the query is that it extract only the news with one name.
Like this:
News of the opportunity A ->Query News for the opportunity A
News of the opportunities A & B â Opportunity A & B doesnât have nothing
What I would like to have:
News A & B â each opportunities have the same news
Some screens here of the properties that I tried to set.
I feel like this should work. Comparing an array to an array should trigger a match if any one item matches in both arrays. What Iâm a bit suspicious on is extra spaces between items in your comma delimited list. Out of curiosity, does anything that includes âStartup Bakeryâ happen to work?
I think Iâm mistaken. Did a quick test. With a Query, all array items need to match on both sides for the query to return a row. Not just one array item. On the other hand, it does work like you want it to with a Relation column (which is why I thought the Query would be the same). The only downside is that you canât include your update boolean in the relation.
This feels like a bug with the Query column to me. In my experience, comparing two arrays should return a match if at least one item is in both arrays.
In the News table, I would create an IF column that returns the âsplit companyâ column values only if âInvestor Updateâ is checked. Then replace the Query in your Opportunities table with a Relation that matches âName copyâ to the IF column.
Another alternative is to not create the IF column, but still create the relation by linking âName copyâ to the âsplit companyâ. Then just set a filter in the collection (if you are only displaying the relation as a collection) to only show rows with âInvestor Updateâ checked.
