Left Join following Noconcatenate - behaves differently when more than one table loaded

[mazacini]

Hi

Code is as follows:

Contracts:LOAD CostCentre,
     Contract#FROM

(biff, embedded labels, table is A$);

Hours2:NoConcatenate load

     RecNo() as Rec,
     CostCentre,
     Field1,
     Field2,
     Field3
         FROM

(biff, embedded labels, table is C$);
left join (Hours2)
load   CostCentre,
     Contract#
Resident Contracts;Drop Table Contracts;

The code works fine when there is a single table X*.xls ie the Contract# field is joined, and a single Hours2 table is created.

However , when there is more than one X*.xls, the first table load behaves as above, but each subsequent table generates a new table - Hours2-1, Hours2-2, Hours2-3, Hours2-4 etc WITHOUT the Contract# field being joined.

If I drop the NOCONCATENATE, the load behaves normally. But I do need the NOCONCATENATE.

Any ideas?

Joe

[mazacini]

Thanks Anders.

I thought the Noconcat only prevented current load from joining previously loaded tables. In fact, it governs the load of tables within the Noconcat statement.

Many thanks

Joe