Extra nodes not needed

[Anonymous]

Greetings,

  I was trying to make updates to my sheets when all of a sudden my numbers were going much higher than they should be.  I checked in my data model and I found what appears to be duplicate tables with numbers in the header (image included).  I am trying to figure out how that happened and need help in removing them so my numbers can be presented correctly.  Thank you in advance to anyone who can help.

Chris

[ogster1974]

If its always worked it would suggest your schema has changed somehow.  Look at your source data and check for new fields or fields being removed You might need to handle the 2 or more datasets to bring them together.

[rwunderlich]

The tables with numbers in the name indicate a load from multiple source files (or SELECT) when the fieldnames in the sources differ. If the field names are the same, Qlik concatenates to the same table. If they differ, a new table is created as tablename-n.

For example, in a wildcard load that loads three files. 

MyTable:
LOAD * 
FROM Sales*.qvd (qvd);

Assume three files. Sales2000.qvd,  Sales2001.qvd and Sales2002.qvd.  All files contain the columns F1, F2.  Sales2001 contains an additional field F9. The output of the load will be:

MyTable:
contents of Sales2000 and Sales2002

MyTable-1:
contents of Sales2001

-Rob