Mapping multiple dimensions to a single column

Use pattern matching to transform multiple dimensions that are mapped to a single column.

For example, if the source data combines the Version and Year data into a column named VerYear:

VerYear,Account,Product,Channel,Data,Description
ACT2008,1275,0,0,150000,1275 - Sale to XYZ Company
ACT2008,1275,0,0,50000,1275 - Sale to PDQ Inc.
ACT2008,1275,0,0,75000,1275 - Sale to XBR Ltd.
ACT2008,1275,0,0,10000,1275 - Maintenance payment from AAA

The transformations will split the data from the single column into the Version and Year dimensions.

In another example, account, department, and company information is in one column. The data is separated by periods, aaaaa.ddd.cccc. If the data value is 12345.234.3456, you can define these mappings as:

Account 12345: 12345.*.*
Department 234: *.234.*
Company 3456: *.*.3456

If the data has a fixed length with no period or character between the values, for example 123452343456, you can define these mappings as:

Account 12345: 12345???????
Department 234: ?????234????
Company 3456: ????????3456