Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
cancel
Showing results for 
Search instead for 
Did you mean: 
Spiller
Contributor
Contributor

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

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

Labels (1)
2 Replies
QFabian
Specialist II
Specialist II

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);

QFabian
Spiller
Contributor
Contributor
Author

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