Issue
There are no built-in tools or utilities available in Sigma to merge lookup table files from multiple sites into a single unified file.
Product Line
Satchwell BAS & Sigma
Environment
Satchwell Sigma
Cause
When consolidating multiple Sigma sites into one, each site may have its own set of lookup tables. Sigma does not provide a native method to merge these tables, requiring manual intervention to avoid data loss or corruption.
Resolution
To manually merge lookup tables from multiple Sigma sites:
-
Export Lookup Tables from Each Site
- Open the lookup tables for Site 2, 3, 4, etc.
- Use the Copy button to copy the data from each required table.
-
Use a Text Editor
- Paste the copied data into a text editor (e.g., Notepad).
- Repeat for all tables from each site.
-
Prepare the Final Lookup Table File
- Open the lookup table for Site 1 (the target site).
- Create a new table for each merged entry.
- Copy and paste the data from the text editor into the new table.
-
Important Formatting Notes
- Start pasting from a vacant line below the last entry to ensure the final line is imported correctly.
- Avoid blank lines above the data, as this can corrupt the top field.
-
Resolve Conflicts
- If any tables have conflicting lookup table numbers, assign a new number.
- Update all associated points to reference the new lookup table number.
