This dispersals table is a prototype demonstration for a virtual reunification of the Wellcome diaspora - items loaned or gifted to other museums and libraries worldwide between Henry Wellcome's death in 1936 and 1982.
Recipient organisations have often recorded former Wellcome identifiers in their own catalogue records, which enables these links to be retrospectively created to legacy Wellcome accession records. But the Wellcome accession and registration systems are complicated to understand, and there are numerous different ways in which these identifiers can be expressed. In consequence, former Wellcome items are often easily identifiable to the human eye, but recipient museums and libraries' records usually require significant amounts of data cleanup before the retrospective connections can be made. The data behind this dispersals table comes from openly accessible catalogue records wherever possible, sometimes supplemented by Wellcome specific details supplied by the museums and libraries concerned.
When you bring additional fields into a conversion, Quickbase often finds inconsistencies. For example, say you're converting your Companies column into its own table. One company, Acme Corporation, has offices in New York, Dallas and Portland. So, when you add the City column to the conversion, Quickbase finds three different locations for Acme. A single value in the column you're converting can only match one value in any additional field. Quickbase needs you to clean up the extra cities before it can create your new table. To do so, you have one of two choices:
|
![]() |