Workflow error
Hi All:
I have created a new Datasource of Trail Balance which is excel source. I have written a complex expression in the logical operator. the logic is, if there is an amount in the debit column,...
Forum Discussion
It sounds as though the script is trying to process a line that does not have the credit/debit data on it - possibly a header line. I would put a check in the complex expression that makes sure the line contains the data - maybe count the instances of api.Parser.Delimiter?
Thank you MarcusH I see. Debit column assigned as column number as "2" for amount. I need to assign the credit column number as "3" for the amount so that program can understand. but i don't see another amount as column in my Delimited Datasource I created. How to add another amount column to map the credit to that?