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.
Alteryx Gallery is experiencing a problem in which system emails are not being sent out. As a result, if you are attempting to sign up for a new account, you may be unable to verify your email address. We are working to solve this as soon as possible and will remove this notice once resolved.
This is built into an app that emails out the processed file to end users. Is there any other way?
I don't want to have the end users change the number format in excel. The numbers refer to client numbers that are between 3 and 9 digits. They don't look right with the comma separators. As a string, excel red flags the fields.
I have run into the same issue, 20 or so out of 1800 records have commas within a number field of data in the output of the render, but prior to the table tool if I include an output to xlsx there are no commas.
It's odd that is only happening to around 20 and I can't figure out any fixes for this.
It doesn't have to do with the number of digits. I tried to converting to string prior to the table tool and then using a column rule to remove any ',' and convert back to number, but got the same results. Four other sheets in the output are using the same data and don't have the same issues. I have remove formatting from this particular sheet and now it works fine. It's not ideal, but it works for now.