How to load field value in script based on field value of other field

[Spiller]

Hi all

For a user story I need to load below fields. We have a new condition now where it should always load the BaselineDate for BaselineSource A, when that source is available.  If not then it should load the other source.

Unfortunately the TaskID is not the same per source. So that makes it more complex. But it could used as identifier as the TaskID for A is always a much higher number than the one from the other source. 

Temp:

Load
ProjectID
TaskID

Inner join (Temp)
Load
BaselineID
BaselineName
TaskID
BaselineDate
BaselineSource

Thanks

Spiller

[QFabian]

Hi @Spiller , please try with this :

Temp:

Load
ProjectID
TaskID

from yoursource1;

Inner join (Temp)
Load
BaselineID
BaselineName
TaskID
BaselineDate
BaselineSource

from yoursource2

where exists (TaskID, TaskID);

[Spiller]

Hi Fabian,

Thanks. Only the TaskIDs loaded in Source1 are the tasks for all BaselineSources. So it doesn't the trick yet using it in the where exists clause in the second load.

Spiller