Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys, I have this subjob
TfileList with the url of a directory TO FileInputExcel TO a tMap to a DDBB
Problem? I don't have the schema of the file of the tFileList, the tMap is empty. How i can get the schema of the Excel file in the tFileList element?
The 'warning' in the Excel element is that I don't have schema there
Hello,
Are all your excel files same schema structure? If so, you need to define schema setting firstly in tfileinputexcel component to read your excel files.
Note: There is no dynamic schema feature in tfileinputexcel component.
And for tfileinputexcel, in the settings, you need to specify the filepath with a global variable : ((String)globalMap.get("tFileList_1_CURRENT_FILEPATH")).
Best regards
Sabrina
Thanks for sharing such great information, I highly appreciate your hard-working skills as the post you published have some great information which is quite beneficial for me, I hope you will post more like that in the future
Hi,
You can't retreive the schema of files in a tFileList. The component is here only to list the files in the specified folder set in the component tFileList
You need to define the schema of tFileInputExcel based on the header columns in your Excel file.
Regards
Shong