Relation Diagram of project

Dear @ebay ,

Just a quick reply:
You need to set up the parameters in the bottom of the view screen by dragging all the fields you use into the designated area so it will look like this:

After deploying and reading the view fields you need to map the Custom view fields:
 

You need to make sure that all columns are in there. You can drag the columns to the tables and columns they originate from.
 

my best practise here is to don;t rename ([ColumnName] As [NewColumnName]) in the view or use this as little as possible so I can use the Auto Map button. This saves me a lot of time.

As on other best practise: I try to use the views as little as possible. 

Hope this helps

= Daniel

Hi all,

as an additional thing to think about: if you are pulling fields with the same name from multiple tables you will probably want to have separate mappings for the field name for each source table. If you are aliasing in your view, you will want to add separate mappings for those as well.

This way, TimeXtender will be able to deal with field name changes properly and your lineage will stay correct. Because this gets pretty complex quickly, as Daniel says: try to minimise using views and only handle a specific complexity in the view instead of all the ET you would want to apply.