Good day! I have a question about something I am struggling with in a workflow. At the end of my workflow I have a basic table tool, and then that connects to a render tool. The render tool is set to output multiple excel files. This part is all working properly. The issue that I encounter is this: The field that is set to a data type "Double" in a select tool earlier in the workflow appears to be perfect when I view in the Browse tool directly before the Basic Table. There are no commas which is exactly how I need to it to be on the excel output. However, after the data goes through the Basic Table and Render tools, the output comes out with commas. I have tried the data cleansing tool between the Table and Render tools, and also tried adding another Select tool between the Basic Table and Render tools but with no success. Any advice? Any suggestions appreciated! I'm attaching some screenshots of my workflow and results.
easiest way to do this is to convert it to a string first. check number/bank number/id are really strings - they just contain numbers.