Alteryx Designer

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Check if all mandatory columns are included

Highlighted
7 - Meteor

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!

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

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,

Highlighted
7 - Meteor

Thanks @Thableaus  this was helpful! 

Labels