Post any question you may have in regards to GoAnywhere Director and let our talented support staff and other users assist you.
I am trying to import an Excel Spreadsheet to the AS/400 using the Read Excel and SQL Insert functions. When I encounter a cell that should contain numeric data but instead is blank, the process fails. Is there a way to have an empty cell replaced with a zero for numeric fields?
Last edited by a_houston
on Fri Nov 20, 2009 10:28 am, edited 1 time in total.
- Verified User
- Posts: 4
- Joined: Fri Jun 05, 2009 11:38 am
- Location: USA
In either the Data element or the individual column elements in the read Excel task, select the system.empty.string variable for the Null Indicator field. Then, when writing from the dataset, specify 0 for the Null Substitute value.
- Support Specialist
- Posts: 65
- Joined: Thu Mar 05, 2009 3:49 pm
Return to Community Forum
Who is online
Users browsing this forum: intl_sp, Support_Rick and 3 guests