problem changing output row set elements

If you have a new question you’d like our support staff to post a response to, please visit our customer community, Data Security Insiders, to pose the question in our Discussion Boards. We have a thread “Ask Our Tech Experts” that our support team monitors on a regular basis, or you can start a new discussion where other GoAnywhere users and support staff can weigh in. Log in or create your new account at

If you need an immediate response, please create a support ticket or contact our support team by email at [email protected].
2 posts Page 1 of 1


Posts: 1
Joined: Fri Jul 29, 2016 2:26 am

Post by AxelN » Mon Aug 01, 2016 3:52 am
Hi there,

i have an issue addressing the data fields from an excel import named "exceldata".
Before i write this data field (index 9) out into an AS400 file, i want to do a substring but cannot get it to work.

I have tried like ${substring(exceldata[9],1,40)} in the "Map from" definition, but this always throws an error.

I never tried this before, can someone please point me in the right direction here?
XM code is attached.

As a second question, is there any way to have a numeric field rounded to 2 decimals during the mapping if it has more than 2 decimals in the excel cell?

Thank you,
(2.7 KiB) Downloaded 550 times


Support Specialist
Posts: 592
Joined: Tue Jul 17, 2012 2:12 pm
Location: Phoenix, AZ

Post by Support_Rick » Mon Aug 01, 2016 6:11 pm

First, I would look into the "ModifyRowset" task. This might help you get what you're looking for instead of the "Map From" definition. It's much simpler to handle these types of situations.

Also, this seems like it might be an issue with "Truncation" errors when inserting data into your SQL Table. You might want to review your JDBC URL to accommodate truncation. Something like:

jdbc:as400://;data truncation=false;dateformat=iso;errors=full;naming=sql;prompt=false;time format=iso;transactionisolation=none;translate binary=true

This way, any data added during that connection would truncate at max width of the field.

Second, your rounding needs to be handled by the insert statement or the select statement of your SQL Function. It's much simpler that way.
Rick Elliott
Lead Solutions Consultant
(402) 944.4242
(800) 949-4696
2 posts Page 1 of 1