My process only appears to be extracting feeCode2 a single time, however it is in a loop.
My preview comes up correctly. My process doesn’t show any errors unless I run it through workflow.
What happens if you do Validate Records (green check) on the entire data file in Design? It’s likely caused by some condition controlling your loop that’s causing it to try to extract it twice. Perhaps because the data is different on the particular record where it’s happening.
Validate Records is going to tell you exactly which record is in error. By default, the Design tool only shows you the first 200 records though. So you need to expand the preview first, then run the validation.
Can you confirm that the file that you use in Workflow (and that errors out) is the exact same one as the one you run in your Datamapper while designing?
To help you properly we would need to see the Template and reproduce the issue. I suggest you open a technical support call at 1-866-348-5863 or through our website.
Since the default number of records validated by the Validate records option in the DataMapper is 200, you can either increase that number to match the number of records in your data file, or you can use the Execute Data Mapping task in Workflow and tick the Validate only option, which will go through the entire file, regardless of the number of records in it.
Balance column contain a period?
If Yes: Map Fee Code, amount chgd, date, amount paid, date, balance
If No: Map Fee Code, larger area near balance
Step to next line
For some reason, when it gets to the Martin Luther Kin part, it throws this error saying the value can’t be mapped twice (feeCode2, which is equivalnent to the “No” fee code mapping.
I would say it’s caused by the same title appearing in two different rows when in fact they are a single book. I don’t know what kind of logic you applied for moving from one detail line to the next, but that’s where I would start investigating.