Hi Manjappa,
If you want to point a criteria field to an Excel column, create the Excel file first, go back to the Criteria tab, choose In, click the button with 3 dots, choose Dynamic Lookup List, click Configure Dyanmic List, select the column you want to use, and click OK twice. Here is an example of how it looks after you make those selections:
I made mine a fixed value since it will also be in column A.
Attached is the script and data file I created. I'm putting the address numbers as inputs in column A and also have it as outputs in column B so I know which address number corresponds to the rest of the data I'm querying.
I hope this helps.
Thanks,
------------------------------
Maria Simpson | Senior Sales Engineer
Winshuttle North America | 4255276647
------------------------------
Original Message:
Sent: 08-22-2022 17:35
From: Manjappa Subramhanya
Subject: Inputting Selection Criteria form .xls to a SAP Query
Team,
I'm writing a script to get person #, email address from SAP table ADR6-E-Mail Addresses (Business Address Services) passing the address # - however, in the criteria design, though I have said that the Add.# = Value to come from a cell, I'm unable to point it to a column - there is no option - could someone please guide me? An example from any other table would also work.
Thank you,
Subbu Manjappa
Mauser Packaging
------------------------------
Manjappa Subramhanya | SAP Analyst
BWAY Corporation | 7324231735
------------------------------