Records displayed not as many as lines fetched shown during Script Execution Progress

[#1]

Hi guys,

This is a noob question that I'm about to ask.

Upon loading a script, in the Script Execution Progress dialog shows that there are some 2mill++ lines being fetched.

So after loading completed, I put a Table Box object and select all of the fields available. But the number of records shown are way lesser that the ones shown in the Script Execution Progress dialog which is 4k++ rows.

There were no selection being made so I was puzzled of the count differences. Can somebody explain to me why this is happening?

Thank you for your kind attention guys.

[#2 · Accepted solution]

Hi,

The table box will display distinct records.

So if all values in a record are repeated, they'll be displayed once.

This could be what's happening in your case.

[#3]

Hi jp_bakhache,

Thank you for your kind attention. Is there anyway to undistinct the table box?

[#4]

Not as far as I know.

If you want, you can add in your script a field as rowno() that will uniquely identify your record and add that in your table box:

Load RowNo() as UniqueID,

etc...