I use a Generic JDBC Execute Snap to run a SQL query which fetches multiple column data and few of them are NUMERIC. The output from this SQL query is an input to the mapper and the mapper is being used to create fixed width text datafile. When I try this expression, how to ensure it is NUMERIC when XYZ is written the text file.
($XYZ + (' ')).substring(0,9)
