What error you get and it seems no error in the code but try with below code
Source:
LOAD Building,
[Jan Actual Dollars],
[Feb Actual Dollars],
[Mar Actual Dollars],
[Apr Actual Dollars],
[May Actual Dollars],
[Jun Actual Dollars],
[Jul Actual Dollars],
[Aug Actual Dollars],
[Sep Actual Dollars],
[Oct Actual Dollars],
[Nov Actual Dollars],
[Dec Actual Dollars],
[Jan Actual SQF],
[Feb Actual SQF],
[Mar Actual SQF],
[Apr Actual SQF],
[May Actual SQF],
[Jun Actual SQF],
[Jul Actual SQF],
[Aug Actual SQF],
[Sep Actual SQF],
[Oct Actual SQF],
[Nov Actual SQF],
[Dec Actual SQF]
FROM
(ooxml, embedded labels, table is [Data ]);
Table:
NoConcatenate
load
left(Building,2) as m,
SubField(Building, ' ', 2) as v,
'SQF' as type
resident Source
where wildmatch(Building, '*SQF*');
Concatenate (Table)
load
left(Building,2) as m,
mid(Building, 5,2) as m2,
SubField(Building, ' ', 3) as v,
'Dollars' as type
resident Source
where wildmatch(Building, '*Dollars*');
DROP Table Source;
