Discussion board where members can get started with QlikView.
I have a Trans table
I have a Rate table
I am trying to join the Rate field in the Rate table to the Trans table for Item equal A.
I have tried this code:
LEFT Join (Trans)LOAD IMonth,
Resident Rate where Item='A'
but this doesn't seem to work.
Go to Solution.
You can do it like this:
Left Join (Trans)LoadMonth,Rate,'A' as ItemResident Rate;
You cannot give any conditions on which the join will take place: 'where item = A' does not work.
The join will happen on shared columns, in this case month. This will result in a table, which you can filter afterwards, e.g. by excluding rows with item='A'.
Another option is to filter the Trans table BEFORE joining it:
where Item = 'A';
drop table Trans;
That seems to be exactly what I needed.