Skip to main content
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
ZoharB
Contributor III
Contributor III

Conditional load with Where clause

Hi,

I am trying to load a qvd table with a condition that one of the fields is connected to another table that is already loaded and defines that field availability. Here is an example:

Load Param01, Param02 from Table01 (qvd)
This table is loaded first in the process and it contains two fields.
The field Param01 is a key field that links between Table01 and Table02.
Now I load the data in Table02 but only records where the corresponding field Param02 in Table01 for the record Param01 complies with the condition.

Load Param03, Param04, Param01 from Table02 (qvd)
where Param02<>5

Is this possible?

Thanks

 

Labels (1)
10 Replies
ZoharB
Contributor III
Contributor III
Author

Finally I got the solution, based on your advise 🙂 Thank you so very much