Issue with excel output missing some data

[christopher_ontkean]

Hi all,

I have a workflow that outputs to an excel file that is missing cells of data. While error checking a process in my workflow, I realized that a few data points were not getting written into the excel file. Unfortunately, I can't share too much due to privacy but I can share this comparison screen shot of the results for the output data viewer in Alteryx and the Excel file itself.

See Record # 94

As you can see, there should be data in the column highlighted in red from excel. There are a few instances of this. Any idea what is causing the disconnect between Alteryx and writing to the excel sheet?

FYI: the file save setting is set to overwrite and I make sure that the excel file is closed before running this output.

[christopher_ontkean]

Update:

I didn't realize this but there is a field conversion error on the output for the data that I am missing. Suggestions on how to remedy this? The column in question is a date column.

[grazitti_sapna · Accepted solution]

Hi @christopher_ontkean , You can resolve this by changing its datatype to V_String from Date. Here is the update:

Error:

Resolution: