Rank: Newbie
Joined: 2/18/2015 Posts: 3 Location: India
|
Problem regarding the Advance Positional mapping
Users- we are facing one unique problem of Advance Positional Schema. According to requirement, I need to create APS which will be a fixed length schema. I need to do mapping of 13 rows with as follows. 00 10 20 (child of 10) 21 (child of 10) 30 (child of 10) 40 (child of 10) 41 (child of 10) 41 (child of 10) 50 60 99
In this schema 00, 10, 50, 60, 99 are parallel to each other whereas 20, 21, 30, 40, 41 are child of 10 and are parallel to each other. The problem what I am facing is while doing a repeated split against a file each and every segment is becoming child of former. For eg. 10 becoming child of 00, 20 becoming child of 10, 21 becoming child of 20 and so on.
I need to know if there is any way in Altova wherein I can make my schema as per requirement. I am also attaching schema file and test file of what I am doing.
File Attachment(s): pos.mft (5kb) : <Rahul Khanna> This the schema file SC_820_218_Hop2_TGLICAP.txt <Rahul Khanna> This file contains the information about the fixed length of all rows. Payment-mft.mfd <Rahul Khanna> This the mfd file which is finally created after using the pos.mft. TGLICA_RI_X12_820_218_2015-08-05_08-20-51_1.xml <Rahul Khanna> XML file for the source. Payment Schema-1.1.0.xsd <Rahul Khanna> Schema file for .mfd file for the source. Test file.txt (8kb) <Rahul Khanna> This is test file or the expected output file that is expected from the mfd file created by using the mft file.
To see what is the length of an element do below. For eg I am taking first 2 elements of 00 row
00,E820_E820_ISA_ST_CD,E820_E820_ISA_ST_CD,string,,,1,2,L,F <This has start from 1 and will go till 2, so length is 2> 00,E820_ISA13_INTCHG_CNTL_NUM,E820_ISA13_INTCHG_CNTL_NUM,string,,,3,11,L,F <This has start from 3 and will go till 11, so length is 8> and so on.
Please let me know in case any more information is needed and in case there is ambiguity in my explanation.
Any guidance will be fine.
File Attachment(s): Test file.txt (8kb) downloaded 129 time(s). SC_820_218_Hop2_TGLICAP.txt (21kb) downloaded 179 time(s). Payment-mft.mfd (214kb) downloaded 209 time(s). pos.mft (96kb) downloaded 189 time(s). TGLICA_RI_X12_820_218_2015-08-05_08-20-51_1.xml (4kb) downloaded 160 time(s). Payment Schema-1.1.0.xsd (24kb) downloaded 147 time(s).
|
Rank: Advanced Member
Joined: 12/13/2005 Posts: 2,856 Location: Mauritius
|
You can use the new functionality with Regular expression for Repeated split so that 00, 10, 50, 60, 99 remain on the same level
|
Rank: Newbie
Joined: 2/18/2015 Posts: 3 Location: India
|
vlad wrote:You can use the new functionality with Regular expression for Repeated split so that 00, 10, 50, 60, 99 remain on the same level
Can you please tell me from where to do it, I do not see an Regular Expression for Repeated Split. I am using Altova enterprise Expression 2015, sp2,x64.
|
Rank: Advanced Member
Joined: 12/13/2005 Posts: 2,856 Location: Mauritius
|
This feature has been added in 2015 release 3:
https://www.altova.com/mapforce/new-features.asp
|