look at the script. Now your datamodell looks better. If you like, you can go on with joining, but it is not necessary. And you can comment the redundant fields like Sector and Sectorname in the Script.
Regards
Roland
//First Table to load: Value: LOAD CompanyID, Month, Year, GrossProfitMargin FROM [.\test.xls] (biff, embedded labels, table is Sheet2$);
Company: LOAD CompanyName, CompanyID, IndustryID FROM test.xls (biff, embedded labels, table is Sheet1$);
Industries: LOAD Industries, Industries as Industry, IndustryID, SectorID FROM test.xls (biff, embedded labels, table is Sheet4$);
Sector: Join (Industries) // put the two tables in one together LOAD Sector, Sector as SectorName, SectorID FROM test.xls (biff, embedded labels, table is Sheet3$);
//tempSector: //LOAD Sector as SectorName //FROM //test.xls //(biff, embedded labels, table is Sheet3$);
//tempIndustries: //LOAD Industries as Industry //FROM //test.xls //(biff, embedded labels, table is Sheet4$);</body>
