I have a set of ETL that use “Lookup” steps that connect to an excel file, the sheet of this file is set as the “table” to connect (see attach).
enter image description here
now I need to use different set of values depending on an input parameter, so I would like to create many sheets in my excel files with the different data to lookup, and I would like also to use an input parameter to connect to the right sheet (the same parameter value is used across the etl in other steps).

following the example attached: if I need to run the ETL for “MPDE” parameter I would like that the lookup step sets the value in “Use a Table or a view” option (or in “Use results of an SQL query”) to “MPDE” in order to fetch the data in that sheet.

thanks in advance

I tried inserting parameter in “advance editor” but the query returns error
enter image description here