it's a file that will be supplied multiple times a day so it's not feasible to convert it every time.

you could use two data sources to load the data then join them together as explained in this Post[/url]

this is by design, here is a quick workaround[/url]