Hi Steve
Yes, you can use the IN operator, and then point to data in an Excel file - either the file you are in (current file) or another file. Please note that you can't have endless values - the total SQL statement can't exceed 65K characters - but it can work for a number of values.
Choose IN operator and then click the "..."
choose dynamic list. and configure
choose the sheet, column and start and end rows. The end row is optional if you have a variable number of inputs.
Hope this helps,
Sigrid
------------------------------
Sigrid Kok
Precisely Software Inc.
------------------------------
Original Message:
Sent: 03-28-2023 07:04
From: Steve Smith
Subject: Winshuttle (12.1) Query using a list of material numbers from an Excel file
Hello, I have used Winshuttle usually for writing Transaction Scripts, so am new to writing QUERIES
I need to produce a QUERY to extract several fields of data from SAP, and I have figured out how to do that, but what I can't figure out is if I can run the query against a select number of material numbers found in an Excel file, instead of trying to write a criteria for the material numbers ?
Is this something like this possible ? I like what I see with Queries, and this seems like an obvious thing to want to do, so I'm hoping many people have done it
------------------------------
Steve Smith
Saint Gobain Pam
------------------------------