Merge Columns
With the Smart BOM import, if the BOM has two or more columns for any fields, users can combine/merge these columns into a single column by assigning the
Note: Merging can be done with space or in JSON format.
Merged with space:
Merged as JSON:
Separate a single column into two or more columns or rows
When BOM has multiple values defined in a single column, then the user can separate such columns into two or more columns as per need.
Understand the separators
Row separator: When multiple MPNs are merged with any separator and placed in a single cell, and we want to separate them into their own rows.
Column separator: When Mfgr and MPN are merged with any separator and placed in a single cell, and we want to separate them into their own columns.
For example, in the below screenshot, '/' is a column separator, and we want to have MPN and Mfgr to be separated into their respective columns. and ',' is the row separator and we want to have each MPN be separated into its own rows.
Steps to separate columns:
After uploading such BOMs, the system will try to automatically identify such columns and it will pop up the below screen.
Users can also manually map such columns by assigning the 'Combined Cell' option to such columns.
Select the Row Separator and/or Column Separator as needed.
In the above example, we have two sets of Mfgr-MPN in which Mfgr-MPN pair is separated by a comma, and Mfgr and MPN are separated by a slash. So we used a comma for the Row Separator and a slash for the Column separator.
Note: Currently, "space, enter, comma( , ) , semicolon( ; ) , colon (:) , Dash( - ) , Underscore( _ ), Hash( # ), Pipe ( | ), slash ( \ ), back slash ( / ), 2 or more space, 3 or more space" are allowed to use for separator.
After clicking on the Apply button, the row, and column are separated as below.
Sometimes there is more than one separator used for Row and/or Column; in this scenario, we can select multiple separators, as seen in the screenshot below.
