loading tables from two folders seperatly

[yacine]

Hello, 

i want to load some tables from two different folders. The tables from the first folder are being loaded, however not all the tables from the second folder are being loaded. Supposing that 5 files from each folder should be loaded. From the first folder, these tables are loaded : Data1, Data1-1, Data1-2, Data1-3, ..., Data1-5. From the second file only the first table is loaded : Data2. The rest of the tables are not loaded. Can someone pls help me out with this. Thank you in advance.

Below is the code:

Data1:

LOAD * FROM ['lib://folder1/data1_Excelsheet*.xls'] (biff, embedded labels, table is DATEN$);

Data2:

LOAD * FROM ['lib://folder2/data2_Excelsheet*.xls'] (biff, embedded labels, table is DATEN$);

[marcus_sommer]

Tables with an identically data-structure will be automatically concatenated - so they don't appear as separate tables. If this happens could you check by adding a filename() as FileName statement within both loads. If this field then contained all your files - all were loaded.

Beside this it seems that your files aren't completely identically and create therefore a lot of synthetic keys and/or circular references. To resolve them you should take a look here:

Get started with developing qlik datamodels - Qlik Community - 1485839

- Marcus