Six 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

1 ACCEPTED SOLUTION

Accepted Solutions
Six 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.

6 REPLIES
Seven Stars

Re: Column(s) missing error in tFileInputDelimited component

Please provide some sample data from your delimited file.
Six 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.

Seven 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
Six 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.

Seven 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
Six 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.