I've seen a number of posts where people have had $orphans created as a result of using the CrossTable function. I'm trying to apply the function, then have a reference to the columns with the table. When I use the following script, I get a nice table:
(ooxml, embedded labels, header is 0 lines, table is Sheet1);
When I introduce the qualify/unqualify statement, I get the following representation of my table:
UNQUALIFY EmployeeId, PositionID, TrainingType, CourseCode;
What can I do to avoid the orphan? I can't get my head around why this would happen and it's ruining the rest of the load of data due to circular load issues. For a change, I can supply the spreadsheet as it isn't sensitive data (see attached).
Any help is, as always, appreciated. Cheers!