Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I'm trying to get a list of all orders done that contains a specific productcode that starts with "JFH".
I tried with "Only"-function but I doesn't seem to work. Any help very appreciated, thanks!
Order:
OrderId | OrderName | OrderDate |
---|---|---|
123 | Mikael Persson | 2017-01-09 |
Invoice:
InvoiceId | InvoiceDate | OrderId |
---|---|---|
7865 | 2017-01-10 | 123 |
InvoiceLine:
InvoiceLineId | ProductCode | ProductPrice | InvoiceId |
---|---|---|---|
56001 | JFH-FEE | 100 | 7865 |
I'm still stucked with only the "false"-alternative.
Would you be able to share a sample where you are trying to do this?
Hi Sunny,
I seems to work if the "order" only contains products that fulfills the condition, but not when the order also have other products.
Thanks again!
My bad, try this
=Aggr(If(WildMatch(Concat({1}DISTINCT '|' & ProductCode & '|', ','), '*|JFH*|*'), 'True', 'False'), OrderId)
Thanks Sunny for helping out and your patience.