Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all!
Hope someone can help me out with the following:
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;
@FrankSl is it possible for you to provide some data set for us to work on it?