Conditional Concatenation

FrankSl — Tue, 19 Jul 2022 11:29:50 GMT

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;

Re: Conditional Concatenation

sidhiq91 — Thu, 21 Jul 2022 11:36:37 GMT

@FrankSl is it possible for you to provide some data set for us to work on it?

topic Re: Conditional Concatenation in App Development

Conditional Concatenation

Re: Conditional Concatenation