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).