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.
Rename one or both of the fields in the load script:
[Arrival Date] as [One Arrival Date],
[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,
Thank you Steve, what happens if the field is from the same data set?
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.
Retrieving data ...