Conversion of contents of file..Hierarchical file.....

[ayan_chaudhuri]

Hi experts

I have a source file which will look like the following

ZHD|D0039001|G|CAPG|D|NEEB|20090420093324

ZPD|20090417||B|4191|

GSP|_A

PCI|1

SCI|0151

DPC|00261|0.0022672942446

SCI|0430

DPC|00043|0.0032362480141

DPC|00109|0.0031630587104

SCI|0105

ZPT|5087|1426342443

the occurrences of ZHD and ZPD are 1..The GSP,PCI,SCI,DPC can be of 0-unbound.ZPT will be of 1 occurence.What will be my file content conversion will look like.....This is a file-to-idoc scenario.I then need to post it to an idoc.

Can anyone will tell me what my file content conversion will look like!!

[Former Member · Accepted solution]

Hi Ayan,

You need to have a key field for this kind of file structure. Without this it would be difficult to read the file into xi.

Regards,

---Satish

[ayan_chaudhuri · Accepted solution]

Hi Satish

I will use the key field..thats fine........I will modify my query a little bit....

ZHD|D0039001|G|CAPG|D|NEEB|20090420093324

ZPD|20090417||B|4191|

GSP|_A

PCI|1

SCI|0151

DPC|00043|0.0032362480141

DPC|00210|0.0012182234860

SCI|0188

DPC|01191|0.0011982322452

DPC|01192|0.0031933347404

SCI|0244

DPC|00040|0.0030303783518

DPC|00206|0.0013075551158

SCI|0393

ZPT|5087|1426342443

If you look at the file little intently, you will find that all the DPC values and SCI values are not happenning in clustered way like all the DPC values of the file are not grouped together...Rather DPC values are grouped in accordance with SCI......I am giving you the relation between DPC and SCI....Against one SCI values there are multiple DPC values .....And this combination of

DPC and SCI can happen multiple times.....This is actually the requirement..

Can this be done using file content conversion!!!...Any help is highly appreciated...

[ayan_chaudhuri]

Closed

[Former Member]

Hi Ayan,

As per the structure which you have provided:

RecordSet Name

Recordset Structure: ZHD,1,ZPD,1,GSP,,PCI,,SCI,,DPC,,ZPT,1

Please provide star symbol for unbounded occurence. How to judge that DPC1 and DPC2 are related to SC1 or so on.So,it will be great help if key fields are present. Otherwise you have to know like how many DPC will appear under one SCI.

ZHD.fieldFixedLengths

ZHD.endSeparators '|'

ZHD.fieldNames

Similarly you have to do for other structures also.

I hope it will be helpful.

Regards,

Nutan

Edited by: nutan champia on Aug 4, 2009 9:04 AM

[ayan_chaudhuri]

Hi nutan

thanks for your suggestion..But I have modified my query a bit on my second post.....That is the actual requirement