cancel
Showing results for 
Search instead for 
Did you mean: 

How to implement like function in bods?

06-28-2019 12:33 PM
1862 views 3 comments
0 Likes
SAP Managed Tags
Subscribe

How to implement like function in bods?

0 Likes

Accepted Solutions (0)

Answers (2)

Answers (2)

werner_daehn
Active Contributor
0 Likes

I read the question as "Is there a 'like' operator in Data Services similar to SQL?".

Yes: https://help.sap.com/viewer/8092b085a68941f6aaa6708685a62b0d/4.2.11/en-US/576c21606d6d1014b3fc9283b0...

Example: The mapping of a column could be

ifthenelse(gender like 'f%', 'female', 'not female')

I know the Operators are listed in the docs under the chapter Scripting but the same syntax can be used in mappings and where clauses also.

Toby_Johnston1
Product and Topic Expert
Product and Topic Expert
0 Likes

Hi Reddy,

If you mean to run a Landscape Analysis Report, you can use it against your IPS landscape as it is essentially a BI Platform with specific plugins for Data Services. Some analysis types won't be available against IPS but the core functionality such as Server & Services Analysis, Patch History, etc can be reported on.

Let me know if that doesn't answer your question

Thanks
Toby