Fixed Width file

[sheema]

In my Job ,the source file is fixed-width file with 30 columns.
But in some rows i see that there are just 26 columns and than the line terminator is placed
and in some rows i have all the 30 columns and than the line terminator.
When i declare my metadata i declare metadata for all 30 columns.
so i am not able to read the file.I am under the impression that
we cannot read this file successfully.Am i right,
or is there any way i can read this file.


Thanks
sheema

[chulett]

Not positive this will work with fixed-width files, but the 'missing' columns must be from the end of the record and not somewhere in the 'middle'. If that's the case, try enabling the 'Suppress row truncation warnings' option on the Format tab.

Assuming this is a Server job as you've marked the post.

[sheema]

Yes,this is server job.The columns which are missing are also the last 4 columns.But i have tried by enabling the ''Suppress row truncation warnings' ,but still i get warnings saying

read_fixedwidth() - row 1, column XXX, required column missing.
Than i selected 'replace' option from the Incomplete column.Now it is working.

Earlier i tried both these options individually but did not put them together.
Now it is working thanks.

[srimitta]

You are trying to read data with less no.of columns in FF stage column grid.

Means: No.of columns in file are not matching No.of columns in FFstage column grid.

[chulett]

Now it is working thanks.

Excellent - please mark your post as Resolved.