topic Re: Ambiguity in no. of rows fetched shown while loading the script and by hovering on the table shown in DataModel in QlikView

Ambiguity in no. of rows fetched shown while loading the script and by hovering on the table shown in DataModel

Anonymous — Thu, 05 Jun 2014 12:27:23 GMT

Hi All,

Generally ,number of rows fetched for a table while executing the script is same as number of rows shown on that table in Data Model when one hovers over the header of that table.

But ,It was not happened in my scenario.

You can see in the attached images that table named "data" shows 35386 rows in loadscript.png while it is 672334 in fromdatamodel.png .

Could anyone know how can I resolve this issue?

Thanks

Re: Ambiguity in no. of rows fetched shown while loading the script and by hovering on the table shown in DataModel

jonathandienst — Thu, 05 Jun 2014 12:34:26 GMT

I suspect that you are doing a join somewhere with a non-unique join key. That can increase the number of rows in the table. Perhaps you should post your load script or (better) a sample of your model illustrating your problem.

HTH

Jonathan

Re: Ambiguity in no. of rows fetched shown while loading the script and by hovering on the table shown in DataModel

alexandros17 — Thu, 05 Jun 2014 12:34:48 GMT

What you see when you load data is number of rows involved in current operation so if you are using join or conditions the number you see is not significant.

try to load only that table, numbers must be equal!

Let me know

Re: Ambiguity in no. of rows fetched shown while loading the script and by hovering on the table shown in DataModel

Thu, 05 Jun 2014 12:35:00 GMT

Could you share your loadscript with us?

If you do any joins and don't drop tables that could lead to this

Re: Ambiguity in no. of rows fetched shown while loading the script and by hovering on the table shown in DataModel

Anonymous — Thu, 05 Jun 2014 13:17:35 GMT

Hi Jonathan,

I checked what you have mentioned and it is resolved now.

Thanks a lot