Sequential_File_1,0: Import warning at record 0:

deesh · Post by **deesh** » Sat Nov 12, 2011 1:28 am

Hi

I have importing the data from sequential file, I am getting the correct reult but below messages are showing as warnings.

can any one help to me in which we get this kind of warnings and solution for that.

Sequential_File_1,0: Field "j" has import error and no default value; data: {j}, at offset: 0
Sequential_File_1,0: Import warning at record 0:

ray.wurlod · Post by **ray.wurlod** » Sat Nov 12, 2011 1:55 am

Do you need to set "First Line is Column Headings" property to True?

deesh · Post by **deesh** » Tue Nov 22, 2011 11:13 pm

there is no option or property like "First Line is Column Headings" in sequential file INPUT.

is there any alternative than above property.

ray.wurlod · Post by **ray.wurlod** » Wed Nov 23, 2011 12:12 am

There is.

Look more closely.

deesh · Post by **deesh** » Wed Nov 23, 2011 6:03 am

Hi,

There is no "First line column Headings" while in sequential file, this sequential file extracting the data with.txt format and sending data to .csv format.

in ouput file, i have given "First line column Headings" =TRUE, but in input sequential property i didn't find.

chulett · Post by **chulett** » Wed Nov 23, 2011 8:04 am

So you are saying that the file you are reading doesn't have a header row in it?

deesh · Post by **deesh** » Wed Nov 23, 2011 10:06 pm

sorry, I mean the sequential file stage doesn't showing the property, while extracting(Input).

ray.wurlod · Post by **ray.wurlod** » Wed Nov 23, 2011 11:17 pm

Are you using File Pattern or Multiple Readers Per Node properties? If so these will block First Line is Column Headings. If you read specific files, however, the First Link is Column Headings property is definitely available.

chulett · Post by **chulett** » Thu Nov 24, 2011 8:43 am

Something that is a little confusing is you keep using "input" and "output" but with the opposite meaning from the stage's standpoint. For us it makes sense to think of "input" as the stage reading and "output" as the stage writing but when it comes to the reality of it and how the tabs are actually named and documented, it is the other way 'round.

The Output tab is used to define how the stage reads a sequential file. Records are output from it into the job.

The Input tab is used to define how the stage writes to a sequential file. Records are input into it by the job.

Just an FYI.

ray.wurlod · Post by **ray.wurlod** » Thu Nov 24, 2011 1:50 pm

The fact that it's an "import" error means that the file is being read.

chulett · Post by **chulett** » Thu Nov 24, 2011 2:59 pm

That, too.