Check if all mandatory columns are included
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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!
Solved! Go to Solution.
- Labels:
- Common Use Cases
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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,
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks @Thableaus this was helpful!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello.
I don't see the solution provided?
