Check if all mandatory columns are included

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!

Common Use Cases

Accepted answers

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,

All comments

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,

Thanks @Thableaus this was helpful!

Hello.

I don't see the solution provided?

Quick Links

Tags

This months top contributors

atcodedog05 19598

Qiu 15867

MarqueeCrew 13708

apathetichell 13703