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

[Anonymous]

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

[jonathandienst · Accepted solution]

Hi

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

[alexandros17]

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

[#4]

Could you share your loadscript with us?

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

[Anonymous]

Hi Jonathan,

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

Thanks a lot