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 |
Solved! Go to Solution.
@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: