Error message

[aparna0208]

Hi All,

My workflow was working fine until I added a crosstab logic to get the output I expected as indicated in below table. When I ran the same workflow the next day and tried to append the results to same file I am getting an error as highlighted below. Can someone please advise as to where it's going wrong and if there is a way to fix it? Attached is the sample workflow for reference

Error: Output Data (28): Incoming field named "11/12/2020" cannot be appended. All incoming fields must match (or be mapped to) a destination field name.

Inspection	11/11/2020
Discovery Data Firm CRD/Branch ID validated	28843
Firm CRD & CRD Number mismatch validated	25070
Firm CRD validated	29065

[Kenda]

Hey @aparna0208 

Are you trying to write your data to an Excel workbook? I have gotten this error before when I have the following configuration in my output tool but there is a field that is trying to write to the file that cannot be appended (because it doesn't yet exist in the workbook)

[aparna0208]

@Kenda thanks for the quick response. Yes, I'm writing the data to an excel file with the same configuration you have mentioned below

[Kenda]

@aparna0208 

In this case, I would recommend either changing the output method to overwrite or ensure that your fields are all present in the Excel workbook before writing to it.

[aparna0208]

I don't think either would work because this data is something I need to track every week to see if it's increasing/decreasing over a period of time. So the output needs to have the history data and keep adding data every week to the existing file. Probably I'll have to see if there is some other workaround

[Kenda]

@aparna0208 

What if you leave your data with the date in rows (i.e. how it is before the Cross Tab tool)? Then you can have consistent fields from week to week (Fail and Value). When you want to analyze the data, you can read it in from the Excel file then Cross Tab it right away from there.

[aparna0208]

Yes, that's what even I've been trying. And, when I want to analyze the output then probably I can read it from the excel file. Thanks for all your inputs on this:)