Issue in writing data to Excel file

Question

Hi team,

I am facing an issue while writing the output data into excel sheet. I have an excel file as shown in image1 and the output from alteryx workflow is showing in image2.

I have included the cell position in output tool to append the data at a particular position. Now the issue is that the data is not in same order always in excel sheet and this results in wrong data update.

Is there any way we can match the first few columns and based on that the data values will get updated in excel sheet.

Thanks

Paridhi

Image1.png

Image2.png

image.png

Paridhi_Agrawal · Answer

@Prometheus  I added a record_ID field in excel file and same in my alteryx output and sort it to get the correct numbers.

Thanks

Prometheus · Answer

@Paridhi_Agrawal It would be easier if you could upload some dummy data and a workflow that you're using to get your output. I don't know what you're doing to the data, so I can't make a recommendation for your output.