September 7, 2023

Suggested Mappings

Define alternate column names to expedite the column matching step

TableFlow now offers "Suggested Mappings" within column configuration settings. Templates define the expected data of the destination data system and are made up of columns. Each column must have a name and key, which are already used for automated column matching. There are often additional, common keywords used to describe the same column. For example, the "Last Name" column could be represented by "l-name", "lname", or "last" in other systems.

When the user provides a file with a column name listed in the suggested mappings array, the mapping is automatically completed for them.

Suggested mappings can be defined in the Admin Dashboard or within in the SDK by using the suggest_mappings array within the columns of the template object.

React SDK Example (docs):

template={{
  columns: [
    {
      name: "First Name",
      key: "first_name",
      required: true
    },
    {
      name: "Last Name",
      key: "last_name",
      description: "Contact's family name",
      suggested_mappings: ["l-name", "lname", "l_name", "last", "lastname"],
      required: true
    },
    {
      name: "Email",
      key: "email",
      required: true
    }
  ]
}}

JavaScript SDK Example (docs):

template: {
  columns: [
    {
      name: "First Name",
      key: "first_name",
      required: true
    },
    {
      name: "Last Name",
      key: "last_name",
      description: "Contact's family name",
      suggested_mappings: ["l-name", "lname", "l_name", "last", "lastname"],
      required: true
    },
    {
      name: "Email",
      key: "email",
      required: true
    }
  ]
}

New to TableFlow?

Sign up for TableFlow cloud and check out our getting started guide to start importing CSV and Excel files from your customers.

What's Next?

We're always looking for ways for TableFlow to make your CSV and Excel imports as seamless as possible. If you have any feedback, suggestions, or if you'd like to contribute to the project, reach out through our GitHub repository.

To the top
Background graphic with dots