Since you have both of your Item and Fact tables already loaded, you can proceed in this way:
ItemID as ItemID2, //renaming field to differenciate with Fact
Load distinct ItemID,
'No class' as Class
where not exists(ItemID2, ItemID);
drop field ItemID2;
Hope this helps.
Thanks very much for your help...
When loading the items
I had put
ItemNum AS ItemNum,
ItemNum as ItemTemp
Then loaded the fact tables calling the item field ItemNum.
Then did this...
OUTER JOIN (Items)
'No Class' AS ItemClass
Where Not Exists(ItemTemp, ItemNum)
Drop Field ItemTemp;