Information Steward - Like operator in Exists-Function

[former_member799084]

Hi experts,

I would like to implement the following logic for one of my clients and hope you have some helpful tips for me. I will first show the requirement, then my current non-functioning solution 😉

I would like to give the end users an Excel spreadsheet in which they can enter values. These values should not appear in a material description in the source dataset, if this is the case then these entries should be considered as wrong.

So I have done the following development in SAP IS, which should actually work:

However, this only works if the entry in both tables is exactly the same! Unfortunately, this is not exactly realistic.

An example:

All materials with the string "ABCD" in the description should be marked as "false".But also materials with the desc. 123ABDC or 12ABDC34, and this is currently not supported by this solution.

So is it possible to code a exists function with a "like operator" in front of the parameter? With pattern, regex etc. I could not find a solution. If you guys know how to code it, please send me the write coding/syntax 🙂

Or do you guys have different ideas, maybe a total different approach? I just want to develop this flexible approach where the customer can decide which values to use in the rules.This would give us the chance to develop a lot of great profiling rules

Hope you can help me on that 🙂
Thanks in advance!

KR

Lukas

[MarcusZwirner]

Hi Lukas,

I'm not aware of a pure IS option to solve your requirement.

The exists function cannot be used with like or any further complex comparison option (it only checks for exact matches according to a SQL where clause like "where <comparison column> = <value>").

But could it be an option to prepare it within a DS job where you have more (and more powerful) built-in functions (like lookup_ext, match_regex etc.) or a match transform. Please refer to https://help.sap.com/docs/SAP_DATA_SERVICES/8092b085a68941f6aaa6708685a62b0d/575fab9b6d6d1014b3fc928... where you can find a description of all Data Services built-in functions and https://help.sap.com/docs/SAP_DATA_SERVICES/8092b085a68941f6aaa6708685a62b0d/576fcacc6d6d1014b3fc928... for a description of the match transform.

I could imagine that such a DS job compares the data from the excel sheet with the source dataset (using whatever complex matching logic) and adds a flag or the matched value from the excel sheet to the source data.

In IS then it would be just a check for a populated flag or added value.

Best regards

Marcus