Skip to main content
Announcements
SYSTEM MAINTENANCE: Thurs., Sept. 19, 1 AM ET, Platform will be unavailable for approx. 60 minutes.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

multiple rows problem

Hi,

I am loading in one file and displaying it in a table. It seems to load the table with 72 rows during 'reload', however when I display it in a table each row occurs 7 times hence I get 504 rows.

Does anyone know where my mistake may be?

Thanks

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

If you're loading more than one table you might have one table with 7 records and one with 72. If there's no relationship between the tables and you add objects from both to a Table Box for example you'll end up with a carthesian product of 504 combinations.

It'll be easier to see why this happens though if you upload an example file with your post.

View solution in original post

2 Replies
Anonymous
Not applicable
Author

If you're loading more than one table you might have one table with 7 records and one with 72. If there's no relationship between the tables and you add objects from both to a Table Box for example you'll end up with a carthesian product of 504 combinations.

It'll be easier to see why this happens though if you upload an example file with your post.

Not applicable
Author

Thanks! that was absolutely spot on.