topic Re: Unlink fields with same name in Connectivity & Data Prep

Unlink fields with same name

Anonymous — Fri, 02 Apr 2021 08:00:54 GMT

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 — Mon, 07 Aug 2017 10:35:46 GMT

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 — Mon, 07 Aug 2017 10:42:13 GMT

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

stevedark — Mon, 07 Aug 2017 11:14:48 GMT

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.