This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I am using the Reporting Tools to format my data into a table then Rendering to a temporary Excel spreadsheet. I noticed that all of the fields from my table are formatted as Numbers once output to Excel. I have tried to use the Select Tool to reformat each column before my Table Tool, but all of the fields still format to Number fields in Excel. I also tried formatting using the Multi-Field Formula Tool to reformat each column before the Table Tool, but still have not been able to get my fields to keep the correct formatting after I render to Excel. Is there a way to do this?
In the Multi field formula, you have to select the fields you want to change. Your screenshot shows that you're only selecting text fields. Keep them as numeric fields in the preceding join and then change the select fields to Numeric in the Multi-field formula tool.
Thanks for the heads up - I made the changes to my Multi-Field Formula. That being said, all of my data fields still seem to be defaulting to Number. If you open the temporary Excel spreadsheet generated in your workflow, all of the columns are stored as a Number as well. I am wondering if it has something to do with outputting to a temporary Excel file? Either way, I am just trying to be able to maintain my formatting for each column once I output to Excel, so that the end users do not have to go in and do this manually.