The Key ColumnIs a thing that determines which column is unique and also by what data is merged (email, order number...) Feature in Boost.spaceCentralization and synchronization platform, where you can organize and manage your data.
Boost.space includes a feature called the Key Column. This feature allows you to merge data from various sources into a single itemItems are rows in records (order/request/invoice/purchase...) in the database, creating a unified and consistent recordOne row in the Boost.space database. These are individual rows under spaces in each module. For example single products, but not their variants..
How the Key Column Works
The Key Column feature is primarily used for data consolidationAct of merging data from more than one source.. It allows for the combination of data from different sources into a single record in the database. This is done by selecting a Key Column that the system will use to merge the data. One unique aspect of this feature is that you can choose a different Key Column for each spaceSubunits are created within modules to maintain organization and clarity, even with large amounts of data., providing you with flexibility to customize according to your needs.
Key Column and Import/Export Processes
The Key Column plays a vital role during the import and export processes in Boost.space. When you import or export data, the Key Column is used to map your data to the correct columns in Boost.space. This ensures that your data is accurately reflected in the system, reducing the possibility of errorsService is unavailable due to a failure, a service responds with unexpected data or the validation of input data fails. or mismatches.
Example of Using the Key Column
Let’s consider an example with contacts. If you choose email as your Key Column, the system will check if an email is already present in Boost.space before creating a new record. So if you attempt to create a contact with the email [email protected]
, Boost.space will check if a contact with that email already exists. If it does, the new information will be merged with the existing record. If it doesn’t, a new record will be created.