Preparing data for Polymer
Polymer works best with structured, tabular data. This means the data is formatted so that each property is contained in a column, with a title and one record per row below. Most data you find in a spreadsheet is formatted this way.
When data imported into Polymer is not structured in this way, we will give a brief warning with some advice on what should be addressed.
Updating a header or starting row
If Polymer is giving you a warning that your header or starting row isn’t being identified correctly, first preview the data. You can do this by clicking the 3 dots to the right of the file name & selecting 'Customize'.
Click 'Select' in the 'Header & Starting Row' section to see your source data & determine whether Polymer is correctly identifying the header row. If you see that the header row is selected correctly, you can disregard the warning message. If not, you will need to update the header row & save your selection.
Difference between a header row & a starting row
The header row is the row of data that contains your column titles. For example, if you have a column of data containing people's names and the title of that column is "Name", then the header row is the row number containing the "Name" text.
The starting row is the first row of data in your dataset. It is typically the row after your header row.For example, if you have a column of data containing people's names & the title of that column is "Name", then the starter is the row number containing the first entry under "Name".
Data manipulation in Polymer
Polymer does not have a feature for data aggregation, editing of cells, or other actions like removing duplicates or empty rows. These will need to be done in the data source or in another tool.
We do however, have some customization options like renaming columns, changing data types, or hiding columns. More details about this can be found in our section on customizing data.