Hi Support,
We are trying to transpose a excel file sheet data columns into rows using tTraspose component, for this we have created schema using excel metadata and attached it to component tFileExcelInput. it works fine with fixed number of columns, but we have different scenario where excel file will have some other new columns for next week data, and with current metadata schema we are not able to map those new columns.
To map new columns we are creating/refreshing metadata schema each time.
Please suggest any component by which we can achieve it, means if any new column will come up with excel file, metadata schema can automatically sync those column into metadata file.
Your quick response will be appreciated.