Forum Discussion
Pass parameter from Cell(s)
Is there some way to pass a parameter to PQ from a value in a cell in the spreadsheet? Or prompt the user for values at runtime? Further, I used to use a tool when I worked with DB2 that would tak...
Seems like this would work as a way to pass a single value (from a single cell) to a query. What if I needed to pass many values - a list of values - to the query? For example, If I have a list of 50 customer ID's and I paste them into a range of cells in the Excel workbook, I would want to pass these values to an "IN" statement in the WHERE clause of the query [WHERE CustomerID in (<list of values from range of cells>)] Is this possible?