What if my entity number is in row number 2 ? I have gone through the FDM help file but struggling to get this right. I have my TB in the following csv format as shown below -
* Amounts in curr
CostCentre Name (Cost Centre Number),,,,,,,
,, Balance,,, Balance,,
Also, I'm using two scripts (one for the amount and the other for entity) as you have mentioned in your reply. My script works only when entity number is in row one but doean't work when entity is in row 2 as given above.
If you look a the example in the FDM admin guide (Section = Storing temporary values), you will see that you will need to perform a test in the script attached to the amount field, to see if the line begins with the word "CostCentre" (uses StrRecord rather than strfield). the example is an exact example of what you are trying to achieve, and it does not matter what line(s) in the data file that it occurs.