Positional Flatfile schema.

hi,

I have a positional flatfile schema to create. 

here's how the file looks

abc pqr xyz ---- fixed(1st record 3 fields with 4 length each)
12  12  12  12  -----(4 fields, 4 length each)
12 12 12 ---------( 3 fileds, 3 length each)
12  12  12  12  
12 12 12 
12  12  12  12  
12 12 12 
adc pqr ------( 2 fields, 4 length each)

Schema structure :
<Header>
<field1>
<field2>
<field3>
<field4>
</Header>
<Record> ---------------------------- The reocrd needs to repeat in a group with record 1 and record 2 in it.
<Record_1>
<R1field1>
<R1field2>
<R1field3>
<R1field4>
</Record_1>
<Record_2>
<R2field1>
<R2field2>
<R2field3>
</Record_2>
</Record>
<Trailer>
<field1>
<field2>
</Trailer>

The record doesnt repeat instead the next lines are carried on in the trailer record. I am not sure where m messing up.

Help appreciated. 

Thanks.

August 22nd, 2015 2:37pm

Hi Priya,

Are you using FF schema wizard, if yes then have you selected only repeating record from the imported flat file. Seems you are selecting all text. 

I would suggest please follow below article for reference,

Flat File Schema creation with Tag Identifiers in the input flat file repeating in a random fashion

Free Windows Admin Tool Kit Click here and download it now
August 22nd, 2015 4:20pm

Kamlesh,

Thanks for the reply.

I have tried what you are suggesting, also have referred the link. It works alright for a scenario where the repeating record set is the last of record in the schema. But i have multiple non repeating records after this. So while adding these non repeating records i pose a problem. They don't work.

Any suggestions?

Thanks.

August 23rd, 2015 9:11am

Hi Priya,

It should work for non repeating records also. Could you please share your input file ?

Free Windows Admin Tool Kit Click here and download it now
August 23rd, 2015 12:55pm

CustNo : 00xx738      XXX XXX AS XXXXX SKI, XXXXXX 5, 1405                                                            
-----------------------------------------------------------------------------------------------------------------------------------
Lin. EAN-NR        Lev-Varenr    VareBetegnelse                        Billed  Enh  BasicPrice    Disc. TotalPrice  LineNet    Moms%
  71 4055xxxxxx874 Bxx804        az-xxxxo K          NGTFLA/FTWWHT/B         1            190              161.50      161.50    25
                    ADI  RABATT 0.95                                          
  72 4055xxxxxx898 Bxx804        az-xxxxo K          NGTFLA/FTWWHT/B         1            190              161.50      161.50    25
                    ADI  RABATT 0.95                                          
  73 405xxxxx04973 B2xxx4        az-xxxxo K          NGTFLA/FTWWHT/B         1            190              161.50      161.50    25
                    ADI  RABATT 0.95                                          
  74 40553xxxx4805 Bxxxx4        az-xxxxo K          NGTFLA/FTWWHT/B         1            190              161.50      161.50    25
                    ADI  RABATT 0.95                                          
  75 405xxxxxx4911 B2xxx4        az-xxxxx K          NGTFLA/FTWWHT/B         1            190              161.50      161.50    25
                    ADI  RABATT 0.95                                          
  76 4055338xxxxx6 B2xxx4        az-fxxxx K          NGTFLA/FTWWHT/B         1            190              161.50      161.50    25
                    ADI  RABATT 0.95                                         

-----------------------------------------------------------------------------------------------------------------------------------
                                                                                             SUM TOTAL               969.00

------------------------------------------------------------------------------------------------------------------------------
August 24th, 2015 1:26am

Hi Priya,

Have created schema for your sample, you can extend for your fields.

ABCDPQRSTWXY
1234123412341234
123123123
1234123412341234
123123123
SUM Total12341234

Have attached schema, please download and check below link.

Folder to Download for your case : SamplePositionalFF

Sample Schema For the input Shared

SchemaHeaderDetailsTrailer

Thanks, SMSVikasK


  • Edited by SMS Vikas K 23 hours 7 minutes ago Hyper Link
  • Marked as answer by Priya VS 19 hours 3 minutes ago
Free Windows Admin Tool Kit Click here and download it now
August 24th, 2015 3:55am

Hi Priya,

Have created schema for your sample, you can extend for your fields.

ABCDPQRSTWXY
1234123412341234
123123123
1234123412341234
123123123
SUM Total12341234

Have attached schema, please download and check below link.

Folder to Download for your case : SamplePositionalFF

Sample Schema For the input Shared

SchemaHeaderDetailsTrailer

Thanks, SMSVikasK


  • Edited by SMS Vikas K Monday, August 24, 2015 7:57 AM Hyper Link
  • Marked as answer by Priya VS Monday, August 24, 2015 12:00 PM
August 24th, 2015 7:51am

Hi Priya,

Have created schema for your sample, you can extend for your fields.

ABCDPQRSTWXY
1234123412341234
123123123
1234123412341234
123123123
SUM Total12341234

Have attached schema, please download and check below link.

Folder to Download for your case : SamplePositionalFF

Sample Schema For the input Shared

SchemaHeaderDetailsTrailer

Thanks, SMSVikasK


  • Edited by SMSVikasK Monday, August 24, 2015 7:57 AM Hyper Link
  • Marked as answer by Priya VS Monday, August 24, 2015 12:00 PM
Free Windows Admin Tool Kit Click here and download it now
August 24th, 2015 7:51am

Hi Priya,

Have created schema for your sample, you can extend for your fields.

ABCDPQRSTWXY
1234123412341234
123123123
1234123412341234
123123123
SUM Total12341234

Have attached schema, please download and check below link.

Folder to Download for your case : SamplePositionalFF

Sample Schema For the input Shared

SchemaHeaderDetailsTrailer

Thanks, SMSVikasK


  • Edited by SMSVikasK Monday, August 24, 2015 7:57 AM Hyper Link
  • Marked as answer by Priya VS Monday, August 24, 2015 12:00 PM
August 24th, 2015 7:51am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics