One of the Query data fields is returned with many leading zeros and the customer would like these zeros to be removed.
Create a transform using the formula =Value(cell).
Be sure to map the cell field (bottom left in image) to an unmapped cell in your script. The software will use this cell to convert the data.
Please note that as per current configuration and design, using Formula is only possible if the Data Type is Excel. Access as a Data Type is not supported.
Please sign in to leave a comment.