Column(s) missing error in tFileInputDelimited component

Seven Stars

Column(s) missing error in tFileInputDelimited component

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


Accepted Solutions
Seven Stars

Re: Column(s) missing error in tFileInputDelimited component

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.


All Replies
Nine Stars

Re: Column(s) missing error in tFileInputDelimited component

Please provide some sample data from your delimited file.
Seven Stars

Re: Column(s) missing error in tFileInputDelimited component

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

Nine Stars

Re: Column(s) missing error in tFileInputDelimited component

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
Seven Stars

Re: Column(s) missing error in tFileInputDelimited component

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.

Nine Stars

Re: Column(s) missing error in tFileInputDelimited component

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
Seven Stars

Re: Column(s) missing error in tFileInputDelimited component

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.

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Why Companies Move to the Cloud: 7 Success Stories

Learn how and why companies are moving to the Cloud

Read Now