Note: Numbers in source fields that will be transferred into the cells of the table you will build can only include numbers and a period for the decimal point. It cannot include characters for thousands separators like commas or spaces.
Sometimes when building a table you might get an error like this:
This dialog box indicates that the error is in source field 1 and also in record 1.
This dialog appeared when building a table from this file:
Looking at the first record in this file, the value for source field 1 in record 1 is 1,257. This number includes a comma for the thousands separator which is not an allowed character for numeric fields.
Solution: Remove any thousands separators from your numeric fields before building your table.
If you build a table from this file and use source field 2 as your numeric field, you will get this error:
This is because record 1 for source field 2 contains a blank. Blanks are not valid numeric fields. Solving this issue can be solved in one of two ways:
Delete the space from the file
Change the file from this:
To this:
Define Missing Values In Your File and/or Table
See: https://beyond2020.freshdesk.com/a/solutions/articles/44002123086