question

@Chris 2 In the source XML, you have a value **Contingent WorkerEmployeeContructorVendor**. Because there is no delimiter, it is not possible to figure out the rule to use to split this single value. Do you know what rule should be used? For example, it could be something like this: there is a predefined list of words, which can be bunched up together in the source XML and need to be split. The combined words which make up the combined value are never outside of that predefined list. Please clarify. Once the rule is defined, converting one shape to another will be a trivial task, though it is worth mentioning that such tasks are best when done outside of the database.