Filtering two fields in two different tables in Script

[mfigueiredo]

Dear Qlik Sense Experts,

I have the following LOAD script, simplified due to confidential data:

Ord_item:
LOAD
Orders,
ProductCd,
Value,
Quantity,
Customer,
Market,
Date
FROM qvd ABC;

Product:
LEFT Keep (Ord_item)
LOAD
ProductCd,
ProductDetail,
ProductType,
Brand,
SubBrand,
Format
FROM qvd XYZ;

What I need is to filter my data with the following conditions:
1) Load only the Products: Apples, Oranges and Pinneaples from the field ProductDetail
2) Additionally, load the Product Cherries (field is ProductDetail same as above), but from only France (field is Market).

I am struggling with Resident and Join and dropping tables and in spite of searching and trying more than 50 solutions my script still has errors...

Can you please help me with the syntax for filtering this data?

Thank you
Mariana

[Digvijay_Singh · Accepted solution]

May be something like this - 

Ord_item:
LOAD
Orders,
ProductCd,
Value,
Quantity,
Customer,
Market,
Date
FROM qvd ABC;

Product:
LEFT Keep (Ord_item)
LOAD
ProductCd,
ProductDetail,
ProductType,
Brand,
SubBrand,
Format
FROM qvd XYZ;

noconcatenate

Ord_item_final:
Load *
resident Ord_item
Where Match(ProductDetail,'Apples','Oranges','Pinneaples') OR (ProductDetail='Cherries' and Market='France');

Drop table Ord_item;

[mfigueiredo]

Thanks! I just tested it and was missing the syntax for the resident and was not using OR.

So simple! I feel a bit silly.

Thank you again!

Mariana