I'd like to ask why the attribute name in excel cannot automaticlly recognized here? and the attribute name cannot be recognized in the "set role" part.
Thanks for your excellent answer, the second solution inspires me a lot!
I still have some doubts about how to actually operate solution 1-"Activate the Synchronize Meta data option in Process menu". Could you please take a screenshot of the position of the operation button?
Best,
Cesar