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:
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.
Steps to separate columns:
After uploading such BOMs, the system will try to automatically identify such columns and it will pop up below the screen.
Users can also manually map such columns by assigning 'Combined Cell' option to such columns.
2. Select the Row Separator and Column Separator as per 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 Row Separator and a slash for the Column separator.
Note: Currently, "space, enter, comma( , ) , semicolon( ; ) , colon (:) , Dash( - ) , Underscore( _ ), Hash( # ), Pipe ( | ), slash ( \ ), back slash ( / )" are allowed to use for separator.
After clicking on Apply button, the row, and column are separated as below.