a tool to verify columns exist, fail to return error

[PangHC]

i would like to have a tool to verify whether the columns are exist or not.

if all exist then pass

else return error and indicate the filename and column missing in error message.

it happen when we using server. the user come back with the missing variable.

but do not know what file are missing that columns.

so if possible, we may have error message like, column "Status" not exist in "Data.xlsx|||Sheet1".

Suggestion Config:  similar to rename tool, but express is error message

[MackStewart]

You need to specify which columns are expected.

You can do this with a text input and dynamic rename.

When you run the workflow, you get warnings listing which inputs are missing.