Access 2 different sources with same data, load one privileged

[Anonymous]

Dear all,

I got two different sources which both give me a date-field "Projektstart" ( the start date of a project). For usual I receive the data from Source 1, but sometimes it is necessary to take it from Source 2, for example when Source 1 doesn't contain data for a project. In 95% of all cases both sources will contain data, in this case I wan't to receive the data from Source 1, because Source 1 may contain wrong data.

Is there a possibility to allocate to both sources the same field in QLIK and how can I instruct QLIK, to take the data from source 1 favored?

Thanks for the answers,

Best regards

Tom Müller

[shraddha_g]

Before Resident T1; line....

Remove comma in last line (after 'as Projektstart')

[Anonymous]

Mistakes are removed, but now I get the error

"Field 'ID' not found', what corresponds to the point that Jonathan made. Is there any possibility (eventually by changing the original source) to get what I want, or do I have to go a completely other way?

Thanks for your help!