Forum Discussion
domtrump
Helper II
Helper IIPass 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...
AntrikshSharma
Community Champion
Community Championdomtrump You can convert that list of values from excel sheet into a List and then by using Table.SelectRows & List.Contains you can filter the rows which database will treat as IN.
Native Query: