(5) Assign Columns to Imported Data
The program prepares the initial assignment of columns. It is then possible to change the assignment manually. The system remembers the user changes and uses it preferably in the same cases.
Assignment of columns is carried out in the following table:
- The table header contains the columns that are required by the program mode to which the import is done.
- In the first table row the input file column is assigned to be forwarded to the appropriate column of data. The columns can be used repeatedly, but of course you can only assign a compatible data type, i.e. you cannot for example use a text column for number.
- In the second table row the multiplier for numbers can be entered, pressing the "Assign" button shows the window in which it is specified how the values with a Yes/No type and similar are treated. The current assignments and other information is displayed in the hint-bubble if the focus is in the appropriate column.
In all cases it is possible to check the result in the part (6) Result of import preview. If any problems arise, an error message is displayed in the window.
If everything is OK, you can complete the import by pressing the "OK" button.