cancel
Showing results for 
Search instead for 
Did you mean: 

cds data manipulation

AJeB
Participant
0 Kudos

hi is this possible in single cds view only if possible how and what syntax i need to use?

table name: tbl_loc

    define view.................
{ // loc1 data must be equal to newyork only tbl_loc.location as loc1, //loc2 data must be equal to canada only tbl_loc.location as loc2 }
Sandra_Rossi
Active Contributor
0 Kudos

Do you mean loc1 should be "newyork" if location is "newyork" otherwise it should be empty?

Do you mean loc2 should be "canada" if location is "canada" otherwise it should be empty?

AJeB
Participant
0 Kudos

yes loc 1 should be newyork only and loc2 is canada otherwise it should be empty because in my cds view i want this output

Accepted Solutions (0)

Answers (0)