AnsweredAssumed Answered

Multiple rows generated when Mapping EDi to CSV

Question asked by TajudeenKaja8661 on Nov 25, 2015
Latest reply on Dec 14, 2015 by Adam Arrowsmith
Hi, I am a bit new with handling EDI profiles and was looking to find some help with a certain mapping.

I am trying to Map a field from Header Loop and a field from Detail loop using qualifiers. That is I need to map N1_04 (if N1_01=SH) and L11_01(if L11_02 is 2I)

Hence expected output should be 
3XXX7    1Z3718670302454320        

Instead I get the following output
371867    1XXXXXXX0        
               1XXXXXXX0

Sample Input -

ST~240~000XXXXX|
BGN~00~XXX~20151118|
N1~SH~NA~25~3XXX7|
N1~BT~~25~3XXX7~01|
LX~1|
L11~1XXXXXXX0~2I~O4|
LS~2710|
MAN~CP~DS~~CP~NA|
L11~2XXXXX8~CR~SHPREF1/|
L11~0XX0 3XXXXX1~CR~SHPREF2/|
L11~2XXXXX9~CR~PKGREF1/|
L11~0XX0 3XXXXX1~CR~PKGREF2/|
AT7~X6~T1~~~20151118~1XX6~LT|
AT7~~~X9~~20151119|
CD3~~~~~CG|LE~2710|
SE~17~000XXXXX5|


0EM40000000IE5G

0EM40000000IE5L

Outcomes