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.
Compare RowID to ParentRowID:
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.