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.
