In this article, we learn about common data loading errors and how to fix them.
Example 1:
- Order_1 is a table with 4 columns and 5 rows of data.
- The output shows 5 rows of data were loaded successfully without any errors.
Example 2:
- In this example, the error is “Field ‘Plant No’ not found.”
- You need to check the field name in your data source. In the inline table, the field is named ‘Plant_No,’ so make sure to update and correct the field name accordingly.
Example 3:
- A synthetic key in Qlik is created automatically when multiple tables have one or more fields with the same name.
- No synthetic keys means there are no fields that are causing confusion or incorrect connections between the tables.
- By renaming fields, removing unnecessary fields, using joins, concatenate function you can resolve the synthetic key error.
