Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
mazacini
Creator III
Creator III

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

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

10 Replies
mazacini
Creator III
Creator III
Author

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