I need your help to filter a particular table. I have two table first product name and second is exchange rate file I need to filter product from product file as per fetch result, apply filter in exchange rate file first filter related country >Product > Media type
In my datatable there are multiple country name my first filter is to apply filter on country like “Austria” than apply filter
on “product” if I choose “LinkExpress” there are two value found (with FC) and without (with FC) l.e “TV, Digital, Static” and I have to apply filter based on “(with FC)” if (with FC) exist filter TV (with FC) if not filter “TV, Digital, Static”
As first scenario I have to apply filter on country > product, if I found media type column blank fetch that row. like Ad Now.
As first scenario I have to apply filter on country and product if I found media type column Concept/Pack - 10 mins and fetch row check if its value contain 10 mins fetch that value Concept/Pack - 10 mins because there other value also exist 15 mins
exchange rate file