topic Column(s) missing error in tFileInputDelimited component in Talend Studio

Column(s) missing error in tFileInputDelimited component

Anonymous — Wed, 27 Jun 2018 13:30:17 GMT

Hi,

We are getting Column(s) missing error in tFileInputDelimited component.We have input file with header and 97 columns data and heders are seperated with '~'.We are trying to read file howver it is throwing below error.

Column(s) missing
Column(s) missing
Column(s) missing
Column(s) missing
Column(s) missing
Column(s) missing
Column(s) missing
Column(s) missing
[ERROR]: artemis_dev.transt_stg_load_param_0_1.Transt_Stg_Load_Param - tFileInputDelimited_2 - Column(s) missing
[ERROR]: artemis_dev.transt_stg_load_param_0_1.Transt_Stg_Load_Param - tFileInputDelimited_2 - Column(s) missing
[ERROR]: artemis_dev.transt_stg_load_param_0_1.Transt_Stg_Load_Param - tFileInputDelimited_2 - Column(s) missing
[ERROR]: artemis_dev.transt_stg_load_param_0_1.Transt_Stg_Load_Param - tFileInputDelimited_2 - Column(s) missing
[ERROR]: artemis_dev.transt_stg_load_param_0_1.Transt_Stg_Load_Param - tFileInputDelimited_2 - Column(s) missing
[ERROR]: artemis_dev.transt_stg_load_param_0_1.Transt_Stg_Load_Param - tFileInputDelimited_2 - Column(s) missing
[ERROR]: artemis_dev.transt_stg_load_param_0_1.Transt_Stg_Load_Param - tFileInputDelimited_2 - Column(s) missing
[ERROR]: artemis_dev.transt_stg_load_param_0_1.Transt_Stg_Load_Param - tFileInputDelimited_2 - Column(s) missing

Regards,

Vivek

Re: Column(s) missing error in tFileInputDelimited component

iamabhishek — Wed, 27 Jun 2018 13:49:05 GMT

Please provide some sample data from your delimited file.

Re: Column(s) missing error in tFileInputDelimited component

Anonymous — Thu, 28 Jun 2018 05:49:28 GMT

will check whether we can provide sample data or not.Meanwhile could you have any idea what could be the cause of this error.

Re: Column(s) missing error in tFileInputDelimited component

iamabhishek — Thu, 28 Jun 2018 05:54:34 GMT

There could be multiple issues -
1. Not all the rows in your input file might have the same number of columns
2. Some separators might be missing

Would be able to pin point the exact cause once we know the sample data and the process that you are trying

Re: Column(s) missing error in tFileInputDelimited component

Anonymous — Fri, 29 Jun 2018 06:50:35 GMT

There may be possibility that each row may not have value for each and every column and may be there are less column separator ('~').

Then how to overcome these type of problem?

We didn't get approval to provide input file.

Re: Column(s) missing error in tFileInputDelimited component

iamabhishek — Fri, 29 Jun 2018 07:22:04 GMT

Okay in that case we would not be able to pinpoint to the actual root cause without viewing the actual/sample data - schema representation.
If not whole file you could had provided the schema/structure of the file & your job layout

Re: Column(s) missing error in tFileInputDelimited component

Anonymous — Fri, 29 Jun 2018 08:01:09 GMT

There may be possibility that each row may not have value for each and every column and may be there are less column separator ('~').

Then how to overcome these type of problem?

We didn't get approval to provide input file.

Re: Column(s) missing error in tFileInputDelimited component

VincentNaveen — Wed, 22 Sep 2021 10:47:54 GMT

Your file may have empty lines at the bottom. Please remove the empty lines from the files. PFA

FILE BEFORE FIX:

FILE AFTER FIX: