topic Re: Rows that are not associated will not load in QlikView

Rows that are not associated will not load

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

I have some problems with a file that not will load properly, probably because I'm doing something wrong and have forgotten how it works.

My Item table contains all transactions and the InOutHistory contains the all sources ever used.

When I run the script will the InoutHistory table only contain rows that have an associated ImportId in the Item table and the total will be around 36.000 rows(InOutHistory).

The file that contain the data has around 172.000 rows and but all rows will not be included in the InOutHistory table.

I have loded the file twice just to see that the data is there and the InOutHistoryTemp below has 172.000 rows, and when I look in the log file can I see that it has fetched all 172.000 rows

What am I missing when loading data in the InOutHistory table ? I want it to include all rows from the source file.

Re: Rows that are not associated will not load

Anonymous — Thu, 07 Dec 2017 10:10:28 GMT

kindly post the sample data from the InoutHistory & InoutHistorytemp

Re: Rows that are not associated will not load

Anonymous — Thu, 07 Dec 2017 10:14:58 GMT

kindly let us know the Scripting logic which you applied for InoutHistory

Becoz when your loading it without any table link (InoutHistorytemp)data is displaying correctly for you

Re: Rows that are not associated will not load

marcus_sommer — Thu, 07 Dec 2017 12:23:31 GMT

How do you check the number of rows - within the table-viewer or with any objects/measures in the gui?

If there are really lesser records in your final-table than in the temp-table there must be anywhere a filtering. This could be happens by a where-clause, a distinct-statement and/or join/keep-loadings to this table and it should be quite easily to find.

- Marcus