Check if all mandatory columns are included

[faresghnaim]

Greetings guys,

I created a macro to add multiple files from a directory (different schemas) and have them output in different files. I am trying to add a new functionality inside the macro where it checks If these files have the mandatory columns ( a list of columns I have), If it includes all these columns it continues, A list of the missing columns is outputted instead.

Does anyone have any idea of what could I do or where could I start?

Any help is appreciated!

Thanks guys!

[Thableaus · Accepted solution]

Hi @faresghnaim 

I'm not gonna hand you a fully developed solution right now, but just to give you a start, please check the Field Info tool.

This tool creates a dataset with your metadata. From that, you can build out the logic to check if the column names and types are ok.

Cheers,

[faresghnaim]

Thanks @Thableaus  this was helpful! 

[lanningb]

Hello.

I don't see the solution provided?