Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
Code is as follows:
Contracts:LOAD CostCentre,
Contract#FROM
(
Hours2:NoConcatenate load
RecNo() as Rec,
CostCentre,
Field1,
Field2,
Field3
FROM
(
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
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