CDS View - Coalesce and case statement not working

[former_member686194]

Hi Experts,

I have developed a CDS view and one of the column in it is of Bill of Lading(BOLNR).

My requirement is to put '#' if BOLNR is initial. I tried with Coalesce and Case Statement with below code but it is not working as expected.

Code1 - coalesce( _likp.bolnr, '#' ) as bolnr,

Code2- cast ( case when _likp.bolnr = ' ' then '#' else _likp.bolnr end as bolnr) as bolnr.

Is there any other away to achieve the above requirement in CDS View?

[BiberM]

Coalesce only works if the value is null, which is currently only possible within a Join.

The Case should work through. I'm currently only at the Phone but is there something like "initial" or is that value not an empty string? In CDS there is much less automatik data type conversion which is also valid for constants.

[mateuszadamus]

Hello,

What is the error message you get?

Or is it just not producing the expected results?

Kind regards,

Mateusz

[maheshpalavalli]

This works right?

cast ( case when likp.bolnr = ' ' then '#' else likp.bolnr end as bolnr ) as test1

or if it is an older version, this also works, you don't need cast.

case when likp.bolnr = '' then '#' else likp.bolnr end as test

and tell us what is not working as well.

[former_member686194]

Hi Mahesh,

By using Case or Coalesce, it is working for some records, but not for all records. Please see below screen shots:

[former_member686194]

Hi All,

the issues with Coalesce and Case is, for some records which are blank, it is working as expected. But some it is showing blank.

Is it because BOLNR is CHAR35 and having Numeric as well as Alphabetical records?

[former_member686194]

Hi All,

For Some records if you use either a case or coalesce it is working but for some records its not working.blank-bolnr.pngnon-blank-bolnr.png

Please refer Attachments for more clarification on the issue.