Skip to Content
0

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

Dec 19, 2016 at 05:46 AM

271

avatar image
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

scn-pic.png (22.0 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Dirk Venken
Dec 19, 2016 at 09:30 AM
0

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

Show 1 Share
10 |10000 characters needed characters left characters exceeded
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 -

scn-pic-rule2.png (20.9 kB)
0