1 person found this helpful
Assuming that this is the entire script, your issue here is that you are not returning the Closing Balance value in the script which will be the value in strField. If your function was called InsertExtraValue you need to include a line at the end of your import script like:
InsertExtraValue = strField
Thanks for the response. I must admit, I don't really get it, but it worked!!
My assumption was the rsAppend would just add onto the load already there.
From what I understood, you are suggesting is that I also need to add something into the script to get the original lines back in. So if the Closing is in field 11 of 11, I would need to specifically pull that into the script as well. So I added a field called Closing_Value
Closing_Value = DW.Utilities.fParseString(strRecord, 11, 11, ",")
Then added a line
FunctionName = Closing Value
Before the End Function
All seems to have worked as I had hoped.
Thanks again for your help.