Automatic field mapping using Macro

[alexis_d]

I have an excel sheet with contains all the header names of my data and the data types for each column names. 

I want to build a macro where it maps the input data with column header names from the excel file and assign the data type as integer, string or double from the excel file rather than assigning it via select tool. 

How can i build such a macro?

[jferrone]

While I have not used it, there appears to be a CReW macro (Dynamic Metadata). I am not sure if it meets your needs, but hopefully it helps.

https://community.alteryx.com/t5/Engine-Works/The-Metadata-Macro/ba-p/2174

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/CReW-Macro-Support/ta-p/465740