В настоящее время я пытаюсь закодировать выражение, но я знаю только, как запросить его в инструкции SQl
SQL:
select * from Orders o
where o.product_name != MBProductName
AND
o.transaction_id in
(
select m.transaction_id from marketBasket m where m.product_name = MBProductName);
Я хочу представить результаты в виде таблицы.
И он выполнит этот запрос, когда я выберу MBProductName.
кто-нибудь может мне помочь с переводом? заранее спасибо
Мои сценарии:
LOAD
Customer_ID,
Customer_Country,
Customer_Gender,
Customer_BirthDate,
Customer_Age_Group,
Customer_Type,
Customer_Age,
Real_age,
Continent,
Country_Name
Orders:
LOAD
Customer_ID,
Employee_ID,
Street_ID,
Order_Date,
Delivery_Date,
Order_ID As %%MarketBasket,
Order_ID,
Order_Type,
Product_ID,
Quantity,
Total_Retail_Price,
CostPrice_Per_Unit,
Discount,
Profit_per_Product,
PrfitRange,
ProfitMarginRange
Products:
LOAD Product_ID,
Product_Line,
Product_Category,
Product_Group,
Product_Name,
Supplier_Country,
Supplier_Name
TmpMarketBasket:
Load
%%MarketBasket AS TmpOrderId,
Product_ID AS TmpProductId,
Order_Date As TmpOrderDate
Resident Orders;
LEFT JOIN
Load
Product_ID AS TmpProdcutId,
Product_Name AS TmpProductName,
Product_Line AS TmpProductLine,
Product_Category As TmpProductCategory,
Product_Group As TmpProductGroup
Resident Products;
MarketBasket:
LOAD
TmpOrderId as %%MarketBasket,
TmpProductName as MBProductName,
TmpProductGroup as MBProductGroup
RESIDENT TmpMarketBasket;
DROP TABLE TmpMarketBasket;