topic Error in schema in FileInputExcel in Talend Studio

Error in schema in FileInputExcel

EvoticTalend — Fri, 15 Nov 2024 23:48:58 GMT

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

Re: Error in schema in FileInputExcel

Anonymous — Wed, 25 Aug 2021 08:19:05 GMT

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

Re: Error in schema in FileInputExcel

HCox1629954209 — Thu, 26 Aug 2021 05:10:55 GMT

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

expresshr

Re: Error in schema in FileInputExcel

GRomain — Thu, 26 Aug 2021 09:41:21 GMT

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

Re: Error in schema in FileInputExcel

Anonymous — Thu, 26 Aug 2021 09:46:16 GMT

You need to define the schema of tFileInputExcel based on the header columns in your Excel file.

Regards

Shong