Join + where statement

[carolin01]

Hello,

I´m new to Qlik View and have some questions on an issue I´m working on. I´ve created two load statements:

1.

fSalesTransactionLoad:

LOAD
     Company,
     FiscalPeriodYear,
     FiscalPeriod,
     OrderPhase,
     Item,
     OrderDate,
FROM

(qvd);
Where???

2.

PrelimenarydProducts:
left join (fSalesTransactionLoad)
LOAD
     H1I as LineOfBusiness,
     Item
Resident vdProducts_ItemGroup;

After having joined the field LineOfBusiness into the table fSalesTransactionLoad I would like to reduce the data I load there. I do not want to load data where the OrderPhase is 3 and the field LineOfBusiness is "Freight" or "Packaging". I tried join the data from the PrelimenarydProducts with a right join first. But Qlik View told me that it could not find the table fSalesTransactionLoad. And if I do a left join then I cannot implement a where statement for the field LineOfBusiness which is joind afterwards. Also I´m unsure how the where statement should look like. Which is the best way to do this? Any ideas?

Best regards

Carolin

[carolin01]

Sorry, this was my fault. I got mixed up with the order phases. Your answer is correct!!!