I have a table with multiple columns of which one column is indicator_source_table . I want talend to read the value in a row corresponding to this column and use the value specified there to import another file.
For eg;
If in a particular row under the indicator_source_table column we get a value of "Net" then talend should import a file named Net.xlsx from my systemor metadata
Hi
You need to iterate the input values and pass it to tfileinputExcel as file name, eg:
tMysqlInput--main(row1)--tFlowToIterate--iterate--tFileinputExcel--main-->tlogrow
on tFileInputExcel, you can set the file path as, eg:
"D:/filepath/"+(String)globalMap.get("row1.indicator_source_table")
The problem im facing is that I reached the tinputfile component but in this component we have to define the input file schema manually so that job runs properly and we can use the input file for other transformations . Is there any way that we can bypass the define schema step because if we are creating a dynamic system this tinputfile can have any table within it whose schema differ.
