Data Loading Errors in Qlik

Vaishali
Nov 8, 2024

--

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.
Table
  • The output shows 5 rows of data were loaded successfully without any errors.
Output

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.

--

--

No responses yet