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 "..."
![](https://higherlogicdownload.s3.amazonaws.com/PRECISELY/MessageImages/42ff2c2bda75482fbab450b196824bb1.png)
choose dynamic list. and configure
![](https://higherlogicdownload.s3.amazonaws.com/PRECISELY/MessageImages/901e3361bd8b4762a99fb05efe65cacf.png)
choose the sheet, column and start and end rows. The end row is optional if you have a variable number of inputs.
![](https://higherlogicdownload.s3.amazonaws.com/PRECISELY/MessageImages/833c94839f374a529cd0b9300f746aca.png)
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
------------------------------