Skip to main content
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Vondox
Contributor
Contributor

Field not found

Hi,
I want to ask for an advice. I have a QlikSense app to be reloaded automatically. For this purpose I have created two tasks in the QMC:
1. task set to the specific day and time - this works correctly, data is reloaded
2. task triggered by successful finish of reload of another task - this one fails with the error message 'Field not found'.

First of all, I am not sure it should mean that the field is not found in the table at all (but in fact the field is there) OR the field is found, but there is some null value which causes the problem. Maybe there is some another problem with my script (below).

Does anyone have any idea what could be the reason for the error message 'Error: Field 'field_id' not found'?

Facts:

  • the field is in the source table
  • the query timeout for the connection is set to maximum
  • Teradata connection is used
  • manual reload run from QMC works correctly

My script in the Load script:

[Fields]:
load
field_id
, field_l0_nm as Field
, field_l1_nm as Field_group
, field_l2_nm as Field_type
;

SQL

SELECT base.field_id
, hier.field_l0_nm
, hier.field_l1_nm
, hier.field_l2_nm
FROM DTB_NAME.LIST_OF_FIELDS AS base
INNER JOIN DTB_NAME.FIELDS_HIERARCHY AS hier
ON base.field_id = hier.field_id
WHERE base.field_id IN (
SELECT field_id
FROM DTB_NAME.REPORT
WHERE field_id IS NOT NULL
AND business_dt >='2024-01-01')
;

 

 Thanks in advance

Labels (1)
1 Reply
anat
Master
Master

try with below code:

[Fields]:
load
field_id
, field_l0_nm as Field
, field_l1_nm as Field_group
, field_l2_nm as Field_type
;

SQL

SELECT base.field_id as field_id
, hier.field_l0_nm as field_l0_nm
, hier.field_l1_nm as field_l1_nm
, hier.field_l2_nm as field_l2_nm
FROM DTB_NAME.LIST_OF_FIELDS AS base
INNER JOIN DTB_NAME.FIELDS_HIERARCHY AS hier
ON base.field_id = hier.field_id
WHERE base.field_id IN (
SELECT field_id
FROM DTB_NAME.REPORT
WHERE field_id IS NOT NULL
AND business_dt >='2024-01-01');