on 10-08-2015 5:35 AM
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.
Yes, load the Excel contents into your database. You can use SAP Data Services for doing that.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.