Errors indicated in Alteryx Output excel file

Xiaorui

Hi,

After running alteryx and get the Alteryx Output excel file, it always has this green error indicator on the cell.

Does anyone know how to remove this in Alteryx, and get the result without error?

(I tried to turn it off in excel, but the number format still is not correct)

apathetichell

you are outputting via output data - Alteryx in create new sheet mode/overwrite sheet or range (without keep existing formatting checked) will output all data as strings. You can use the render tool to output numbers as numbers - or you can use output data to overwrite an existing range and keep the existing formatting (ie numbers) using output data by passing in a full range to a preformated location (is file.xlx|sheet1$A1:F500)