DSXchange

I tried that also, but when i remove the record length=fixed option, I get the error as

"Field "REC_TYPE" lacks whitespace delimiter, at offset: 5"

I just wonder if it is so difficult to work with Fixed length file!!

Regards,
Divya

The header length was not same as the other records, so I removed the header. Now my file has the following data. CASDC142585654DAFSD74586KDJMEN CASDC142585655DAFSD74586KDJMEN CASDC142585656DAFSD74586KDJMEN CASDC142585657DAFSD74586KDJMEN CASDC142585658DAFSD74586KDJMEN CASDC142585659DAFSD74586KDJMEN ...

There are 5 fields with length 5, 9, 5, 5, 6 respectively.

I got many replies from forum, but I am still not able to view the data.

Regards,
Divya

Hi, My sample file is something like this. Header CASDC142585654DAFSD74586KDJMEN CASDC142585655DAFSD74586KDJMEN CASDC142585656DAFSD74586KDJMEN CASDC142585657DAFSD74586KDJMEN CASDC142585658DAFSD74586KDJMEN CASDC142585659DAFSD74586KDJMEN CASDC142585660DAFSD74586KDJMEN CASDC142585661DAFSD74586KDJMEN CA...

Use Record Delimiter String = DOS Format , not Record Delimiter = UNIX newline (because your server is on Windows). ... I used the above settings also, but couldn't view it. I get the same error "record_length=fixed" (no length given) and record field format is variable-length. The first ...

Ya I tried with record delimiter as UNIX Newline also, but still not able to view it.

Can you provide me with the entire flow and also the settings for the import.

dxk9 wrote: The file format,

fields length
AAA 15
BBB 16
CCC 11
DDD 64
EEE 64
FFF 24
GGG 32
HHH 50

Regards,
Divya

I have only 276 characters per record. All are of the same length.

Have no clue about the error as its the first time that I am working on the fixed length file as input.


Regards,
Divya

I checked the file, it seems to be fine only.
Can anybody give a way to view a fixed length sequential file.

Assume this is the format,

fields length
AAA 15
BBB 16
CCC 11
DDD 64
EEE 64
FFF 24
GGG 32
HHH 50


Regards,
Divya

I have already imported the entire file as a single field and then separated it to various targets based on the row_type ( 1st field), Now when I try to take one of those target file(fixed length) as input and try to read it, I am not able to view the data. The properties I set were: Record Length =...

I have a file containing different row types. Each row type has different number of columns of fixed length. Eg: Header AAA field1(4) field2(11) field3(6) field4(7) field5(14) BBB field1(9) field2(1) field3(16) field4(6) field5(4) field6(10) field7(11) field8(6) field9(2) field10(14) CCC field1(7) ...

Try to collect those two rejects in a sequential file and examine the values and length of all the fields in those records.

This will help you in detecting where the problem is actually with.

Regards,
Divya

Just join the Key column with full outer join.This will give the desired output.

a. Input1 (fa,fb)
b. Input2 (fc,fd)
c. Join fa,fc (full outer join)
d. Pull fk(fa,fb),fc,fd to target.


Regards,
Divya

Svengiyil,

As per your requirement, you have 2 columns, want to group by Col1 and also want both the Cols in the output... which is similar to sorting by Col1.

Plz let me know if my understanding of the requirement is wrong.

Regards,
Divya

Selected ones..

Regards,
Divya

Can you explain the requirement clearly. Its kind of confusing to me.

Regards,
Divya