Hello

i would like to setup an ETL which takes different excel file (each with an unique field structure) and stores them in a single table with the help of an auxiliary table in which is stored a mapping between each file columns and the table columns.

The auxiliary table is something like this:

XLS_FILENAME | XLS_COLUMN | TABLE_COLUMN
file1.xls | file1_col1 | table_col1
file1.xls | file1_col2 | table_col2
file2.xls | file2_col1 | table_col2
file2.xls | file2_col2 | table_col1


with the help of a "row denormalizer" step i can setup a stream with this structure:

XLS_FILENAME | TABLE_COL1 | TABLE_COL2
file1.xls | file1_col1 | file1_col2
file2.xls | file2_col2 | file2_col1

but then i'm unable to tell the "Excel Input" step to get the column name stored in the variable "TABLE_COL1" as it seems that the name of the column specifiend in the "Fields" tab in "Excel Input" step doesn't accepts variables.

Any idea in how to setup this ETL properly? (if it's possible to do so..)

Thanks,
Alessandro