How to Lookup and save Multiple Records/Values in Information Steward

[Former Member]

Hello,

We are on Information Steward 4.2 and working on Master data quality
checks using Data Insight - Rules.

We want to configure a Rule in Information Steward, that would Lookup into tables from ECC for Data Comparison.

However while doing LOOKUP we found that this operation returns only one record.

Requirement is to Lookup Multiple Records in Information Steward and Store the Values into the Table/Range/Array for the purpose of comparison.

Please check the attached screenshot that mentions the requirement of one of the Rules that we want to create.

scn-pic.png

For, this we would need to save the Company Codes of Vendor into a Table / Array / Range kind of Structure. And then compare the company Codes of Alternate Payee with those saved in the Range.

Concerns -->
1.Is there Table/ Range/ Array type of structures available in Information Steward that can store multiple values?
2.In Information Steward we could not find any Iteration or Loop related Operator, that can process one record multiple times.
3.The LOOKUP Operator only returns a single record. It does not return all the records that match the Input.
4.While doing a LOOKUP, is there a possibility to provide a Condition (Not Equal, Match Pattern, etc) for the lookup

Please advice.

Thanks & Regards,

Rupali Singh

[deshmukh]

Hi,

Were you able to find the solution for this.

My requirement is also similar

I need to write a rule for this scenario as per the attachment. For me its looks little tricky. Can someone please provide the rule logic.

If i briefly explain the requirement.

We need to show such Vendor numbers in BO Webi report (in our case) which are not blocked on Central posting block 'LFA1-SPERR' when that vendor is blocked for Posting for All company codes 'LFB1-SPERR'.

LFA1 and LFB1 are joined with Inner join on LFA1.Lifnr=LFB1.Lifnr.

Check attachment for more understanding.

lfa1-lfb1.png

[former_member187605]

Use views.

1. View V1, columns LIFNR, LNRZA, BUKRS, join LFA1 to LFB1 on LFA1.LIFNR = LFB1.LIFNR
2. View V2, columns LIFNR, LNRZA, V2.BUKRS, LFB1.BUKRS as BUKRS2, left outer join V1 to LFB1 on V1.LNRZA = LFB1.LIFNR and V1.BUKRS = LFB1.BUKRS

Define rule BUKRS2 is not null

[Former Member]

Hello Dirk,

Thanks for the solution. We can solve this particular rule with joins. But we also have other rules that would need multiple lookups.

For example -

Rule : For a Vendor If vendor country = TR ,only exist for company codes TUR & BKT then language should be = TR , and if vendor exist for any other company code as well, language should be EN.

For this I suppose we would need the provision to read multiple records from table and to be able to save them.

OR

While doing a LOOKUP, if there is a possibility to provide a Condition (Not Equal, Match Pattern, etc) for the lookup.

Please suggest.

Please check screenshot for more details -