If nested table contains specific row

[flygstolen_fred]

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

[flygstolen_fred]

I'm still stucked with only the "false"-alternative.

[sunny_talwar]

Would you be able to share a sample where you are trying to do this?

[flygstolen_fred]

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!

[sunny_talwar · Accepted solution]

My bad, try this

=Aggr(If(WildMatch(Concat({1}DISTINCT '|' & ProductCode & '|', ','), '*|JFH*|*'), 'True', 'False'), OrderId)

[flygstolen_fred]

Thanks Sunny for helping out and your patience.