Report which pulls from multiple tables used to validate data coming into a process

Michael Gerdes

i have a scenario where the business would like to validate data coming into a process and check to see if this data set has already been visited (decision made on how to handle it), it it was decided upon, then the record would adopt certain fields and the record would move into the tables. If it was not visited before (Quality measure in the process), then it would sit in this table until someone made a decision and then it would move into the tables.

My question is this: I have 52 tables which comprise of valid business decisions (basically they are copies of the same table, just decisions made through out each week of a year) if I build a report which incorporates these tables, will my Data mesh which checks this report for a Unique record find the record if the report only shows 500 records on a page (consider there being 5,000 unique records in each of the 52 tables)...

Thanks Team,

Michael😀

Genevieve P.

Hi @Michael Gerdes

Data Mesh will review the Report it its entirety, not just the first page. However, based on the Smartsheet API documentation (Data Mesh uses the API), it looks like the Report limit is 50,000 rows (see here). This means there would need to be some other criteria in your report that's looking across these 52 sheets in order to filter down the data.

Hope that helps!

Cheers,

Genevieve

Genevieve P.

Hi @Michael Gerdes

Data Mesh will review the Report it its entirety, not just the first page. However, based on the Smartsheet API documentation (Data Mesh uses the API), it looks like the Report limit is 50,000 rows (see here). This means there would need to be some other criteria in your report that's looking across these 52 sheets in order to filter down the data.

Hope that helps!

Cheers,

Genevieve

Michael Gerdes

Perfect!! thanks Genevieve... appreciate your quick response... I can do that...