Hi, I got one concept after doin

[vrs1008]

Hi,

I got one concept after doing some R&D on Mercator. I wanted to conform if this is on the right line or not...

If the element is occuring multiple times in the input file & has a mapping at the output side in the segment which is occuring only once then,

while mapping in to the output filed, Map will loop through all the occurences of the DTP Segment in the input file till it find some element to map in the output element. Moment it finds something to map, it ignore rest of the repeating things in the Input file.

e.g.:-

Input File has:-

DTP*301*D8***
DTP*348*D8*20040101**
DTP*305*D8*20020303**

Here 4th element of the DTP segment needs to be mapped in the "Date_out" Element of the output card which occures only once in the output tree.

While mapping, It takes DTP*301 first, it finds nothing at 4th element, It takes DTP*348, It finds "20040101". It maps this & ignore 3rd occurence. The output in this case will be "20040101".

My question is:-

Since "Date_out" occures only once, how can it look for the second occurence of the DTP segment?? It should map the first occurenece & neglect the rest DTP segment....but i observed the above thing...

Please expalin as i need to solve few things on this fact.

Regards,
Vibhav1008

 

[janhes]

I think it's because you ouly have a single output field so it can only map one value to it.
Record 1 maps nothing. Record 2 maps a value. Record 3 is ignored.