Loading multiple UDA's via Data Management

In a recent project to migrate an existing application from on premise to PBCS we were tasked a straight forward ODI metadata load to a Data Management load - seemed simple enough and was going smooth until we had to load more that one UDA.

I'm not going to go through the process of setting up a metadata load - there are already a few blogs around for that, my pick would be John Goodwin's blog

Our load file in this case is tab delimited, with the two UDA's in double quotes with a tab separating them

We have set the data mapping as a simple like * to * the data validates without any issues and looks ok

While the data load validates if fails on Export with the following error stating the number of fields are wrong.

Looking at the error message it seems that we had to change the delimiter between the UDA's , ODI is comma separated so we tried that,  passing on validation on Export, so we look at the member properties only to find a single UDA has loaded

Not really what we were after, so we revert back to the original format however we adjust the mapping from a straight * to "*"

This time on the import looks like 

 So we are on the right track looking at the final result we can have success

So there you have it, multiple UDA's via Data Management, the solution is simple enough just ensure that there are double quotes around the string of UDA's.