How to lookup for multiple values from an excel file in Information Steward?

[Former Member]

Hello guys,

We have the below mentioned scenario;

a. We have reference data listed in an excel which has multiple columns - e.g. Code, Description, Optional,... etc.

b. However, a Code can have multiple records in the excel. (for whatever reason)

c. Now, I want to evaluate the conformity score of data in a table based on the values in this excel. (i.e. to validate the description stored in the table against the values in the excel based on the Code)

d. Logic I could think of is ---> Table.Description in (Excel.Description values)

e. As per my understanding, I cannot use the 'Lookup' function in Information Steward to return multiple values.

f. Also, I cannot use SQL function on data stored in a file/view.

My advice to the team is to create a reference table in the database where we have the actual table and perform the logic in point-d using SQL function.

Please advise.

Thanks.

[former_member187605 · Accepted solution]

Yes, load the Excel contents into your database. You can use SAP Data Services for doing that.

[Former Member · Accepted solution]

Hi Dirk,

Thank you for the response. Do you think there is any other way to achieve this in IS ? Just want to be absolutely sure before requesting to create a table.

Thanks.

[former_member187605 · Accepted solution]

Not that I know, I am sorry.