Qlik Community

Qlik Connectors Discussions

Discussion Board for collaboration regarding Qlik Connectors.

lilley90
Not applicable

Unlink fields with same name

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

3 Replies
stevedark
Not applicable

Re: Unlink fields with same name

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

lilley90
Not applicable

Re: Unlink fields with same name

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

stevedark
Not applicable

Re: Unlink fields with same name

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.