not sure why my output data was truncated, please see below workflow and output excel. i notice why the data was negative the output file was truncated, if it was positive the file was fine.
Solved! Go to Solution.
@Beckyli hi! Just ran a little simulation:
Before it goes into the Table:
After:
So the table configuration is the issue. I'll have a dig in the table settings. At least we can see where it is
@Beckyli well, as a workaround. Change the datatypes to V_WStrings of a decent size, i.e. 200:
It can't truncate it if it's a string haha!
If you need to change the Datatype of multiple columns to V_WStrings, I wouldn't do it using the Select tool. That's repetitive and monotonous. Use the Multi-Field tool:
All the best,
BS
we want to all below column are the numbers, and the type should be Double, which can be calculated. if it change to string it doesn't work for sum amount.
Can't you just add a Select tool here (just before it goes into the table tool - see the black cross I put in the picture above). All the calculations have been completed at this point. You would simply be changing the Datatypes from doubles to Strings. You aren't doing anymore calculations past this point, it's just getting put into a table and then exported to an excel file.
It's just one workaround, of course, there may be settings in the Table tool that stop the truncation occurring 😁
