Im trying to concatenate 2 loads but only depending on the condition that the dataset contains 1 of 3 possible values. Id the dataset doesnt contain that value, I want only to output the first load, without concatenation.
I have tried the following, but the result show no concatetaned data at all, in not one resultset.
Any thoughts? Thansk in advance!
Script:
Load Value1, Value2, TITEL_DESC
Resident Data Where $(sql)
order by TITEL_DESC ASC;
If match (TITEL_DESC,'title1', 'title2', 'title3') then Concatenate load Value1, Value2, TITEL_DESC
Resident Data where TITEL_DESC = 'TitleX' order by TITEL_DESC ASC ;
else Load Value1, Value2, TITEL_DESC
Resident Data Where $(sql) order by TITEL_DESC ASC; endif;
