Thanks Phil,

I definitely have questions. It's late on Friday and my logic has gone out the window.

My questions are basically,

1.where do I put it within my data flow

Ex: My data flows goes like this;

1.Load Invoice and payment data

2. Sort Invoice and payment data

3. Join Invoice and Payment Data

4. Convert the Data

5. Set defaults and derived columns

6. Load in the Destination

2. My Invoice Data has the Currency Type.

IF the currency type = 'CAD' then I want to look at a View and append the Rate for the Matching date to the data befor it goes to the destination.

Hope this makes sense...and Thanks