Column(s) missing error in tFileInputDelimited component

[Anonymous]

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

[iamabhishek]

Please provide some sample data from your delimited file.

[Anonymous]

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

[iamabhishek]

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

[Anonymous]

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.

[iamabhishek]

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

[Anonymous · Accepted solution]

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.

[VincentNaveen]

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

FILE BEFORE FIX:

FILE AFTER FIX: