We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Basic Table, Render, and Excel Formatting in Outputs

Brook_G
7 - Meteor

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. 

2 REPLIES 2
apathetichell
20 - Arcturus

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.

Thableaus
17 - Castor
17 - Castor

Hi @Brook_G 

 

Could you change the field to String Type before the Table Tool?


Cheers,

Labels
Top Solution Authors