Flat File Content

, ,
41

Yes, RMG. U R Correct. I haven’t set the MaxRepeat as Unlimited. I have done that its fine. Thanks for your nice tips.

42

Hi, I have a Fixed length Flat file like

SampleRecSiva12345

The flat file schema is :

SampleRec

  • Name
  • Age

And i gave the Record length as 21. And field Delimiter : *.

but while running the ff schema i am getting like as follows

name: SampleRec
Age : Siva

And isValid : true.

What is the problem here, is there any settings issue. Please Help me.

Thanks

43

Looks like you are sending your record name as one of the fields.
SampleRecSiva12345
Based on your example above you have 3 fields in SampleRec, Siva and 12345. Therefore your output is correct.
You need to add Recordname as the first field in your schema. Then ignore it in your processing.

To get the output you desire your data would have to look like this:
Siva*12345

Also set your field delimiter to newline and don’t make it fixed length.

44

Hi,Can any body give me a sample variable length Flat file.

I have assumed one like as below.

9test*Siva

9- Length of the record
test- record name
*- field seperator
Siva- Field value

Is this a valid variable length flat file?

If not correct me .

Thanks

45

Siva,

What you are trying to achieve?

Hope you understood the above postings and thoughts by me and Chris.

46

I have a single record type based flatfile schema with no record identifier. So I have defined a dictionary and assigned the same as default record type. This works pretty well and parses the records as desired. But it gives me the results as document array of

/ffvalues/recordWithNoId.

For generalization purpose (with multi-record types) I need the docuement array in

/ffvalues/DETAILS

How do I get this? I tried the alternate name (in properties tab) stuff in vain… any clues???

Thanks in advance

47

After the parsing, map the contents of ffvakues/recordWithNoID to ffvalues/DETAILS using a MAP step and that should work