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