Unlink fields with same name

[Anonymous]

Hi, I have two tables both with Arrival Date as the field. I need that field in both tables but do not want them impact on each others selections.

Many thanks

Jess

[stevedark]

Rename one or both of the fields in the load script:

[Arrival Date] as [One Arrival Date],

and

[Arrival Date] as [Other Arrival Date],

If you have other manipulations that will be in the same line:

Date(DayStart([Arrival Date]), 'DD MMM YYYY') as [One Arrival Date],

Hope that helps,

Steve

[Anonymous]

Thank you Steve, what happens if the field is from the same data set?

[stevedark]

I'm not sure I follow.  Do you mean different tables in the same database?

If so, this will not be an issue, just rename one or the other or both, as above.