Select to view content in your preferred language

Unequal number of Records in Tabs

299
1
11-20-2023 05:53 PM
BenyaminWishnek
New Contributor

Hello, 

There are an unequal number of records in the two tabs when I export data from S123 to Excel.  The survey says there are 560 records and there are 560 records in one of the tabs, but 561 records in the other tab.  If I want to combine both tabs into a single tab, how do I rectify the mismatch un record numbers with out deleting anything that is incorrect?  Screenshots of both tabs with numbers of records in each are below.

BenyaminWishnek_0-1700531479680.png

BenyaminWishnek_1-1700531558584.png

 

 

0 Kudos
1 Reply
abureaux
MVP Frequent Contributor

Compare RowID to ParentRowID:

abureaux_0-1700584073850.png

I'd export the data and do some simple Excel merging. Doesn't look to be much data there.

Wouldn't the mismatch come from that related table being a repeat? The extra 1 could be accounted for by user error.

0 Kudos