How to add error if the sheets imported using Macro do not have same fields

Data_Alter

I have workflow where I import all the tabs of an excel using a Macro

But I want the workflow to let me know if all the fields in file are not same. So I am making the workflow output the table below.

I want the workflow to show an error because the field highlighted in red is not same as others.

First_F1	First_F2	First_F3	First_F4	First_F5	First_F6	First_F7	First_F8	First_F9
Cost Centre	Expense Code	Posting date	Source	Reference	Narrative	Balance	Daybook date	TRQ
Cost Centre	Expense Code	Posting date	Source	Reference	Narrative	Balance	Daybook date	Daybook number 1
Cost Centre	Expense Code	Posting date	Source	Reference	Narrative	Balance	Daybook date	Daybook number 1

DataNath

@Data_Alter would something like this work if you were to implement it after the macro output? This approach:

1 - Transposes the data, bringing all field names + values into rows

2 - Groups by field name and performs a distinct count of all values within that group

3 - As we're looking for differences, we ought to be concerned when that count distinct is higher than 1 and so we use a message tool here to trigger on that condition being met

Workflow runs fine as all fields have identical values:

Error message is triggered, due to the 'TRQ' difference:

Error upon field differences.yxmd