Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

qvraj123
Contributor II

Mapping Load from Resident - field not found error

Hi All,

Thanks for your time, - could any please suggest what could be wrong in the below - I have Resident Table1 Load statement before what I listed below but I am using different column names

//I have all the below in one tab - in the previous tab I have another load statement and it is completely different (different column names)

load for Table1;

//Get the list 
LinuxManagedVMs_TMP:
NOCONCATENATE LOAD
UPPER(TRIM(systemname))   AS ManagedVM_SystemName,
UPPER(OS_Name)                   AS ManagedVM_OSName,
UPPER(TRIM(systemtype))       AS ManagedVM_SystemType,
UPPER(TRIM(contact_group))  AS ManagedVM_ContactGroup
RESIDENT Table1
WHERE WILDMATCH(UPPER(OS_Name),'*RED HAT*') <> 0
AND UPPER(TRIM(systemtype))='VIRTUAL'
AND WILDMATCH(UPPER(TRIM(contact_group)),'*CLOUD*')=0 ;
 
LinuxManagedVMsDataTMP:
noconcatenate LOAD DISTINCT ManagedVM_SystemName  AS MangedVM_HOST
RESIDENT LinuxManagedVMs_TMP;

INNER JOIN( LinuxManagedVMsDataTMP)

LOAD DISTINCT HOST  AS MangedVM_HOST
FROM  excelfile;


LinuxManagedVMsData:
NOCONCATENATE
LOAD
MangedVM_HOST,
'Linux Managed VM'
AS DerivedProductFlag
RESIDENT LinuxManagedVMsDataTMP;

//DROP THE TEMP TABLE
DROP TABLE LinuxManagedVMsDataTMP;

MapLinuxManagedVMs:
MAPPING LOAD
ManagedVM_HOST,
DerivedProductFlag
RESIDENT  LinuxManagedVMsData;

This is where I have the FIELD NOT FOUND error - as soon as I get to the mapping load I get this error - thanks a lot - please let me know if you need more details

1 Solution

Accepted Solutions
dilipranjith
Honored Contributor

Re: Mapping Load from Resident - field not found error

You have typo a missing 'a; on

LinuxManagedVMsData:
NOCONCATENATE
LOAD
ManagedVM_HOST,
'Linux Managed VM'
AS DerivedProductFlag
RESIDENT LinuxManagedVMsDataTMP;

6 Replies

Re: Mapping Load from Resident - field not found error

Hi, you can try setting an "Exit Script;" after the "DROP TABLE LinuxManagedVMsDataTMP;" para comprobar si los campos existen en LinuxManagedVMsData.


Puede que el inner join que realiza antes esté dejando la tabla sin filas.

qvraj123
Contributor II

Re: Mapping Load from Resident - field not found error

Hi Ruben, I have just added another LOAD statement where I used the ApplyMap but I still get the same error

why do we need the exit script? If we use the exit script what happens to the mapping table? will it be still available

thanks a lot for your time

dilipranjith
Honored Contributor

Re: Mapping Load from Resident - field not found error

You have typo a missing 'a; on

LinuxManagedVMsData:
NOCONCATENATE
LOAD
ManagedVM_HOST,
'Linux Managed VM'
AS DerivedProductFlag
RESIDENT LinuxManagedVMsDataTMP;

Re: Mapping Load from Resident - field not found error

No, it's only to check what fields are loaded in LinuxManagedVMsData table, after checking corrections should be applied and exit script it should be removed. sorry, I switched to spanish in last answer

Seems Dilip has found a typo that can be the real issue.

Highlighted
qvraj123
Contributor II

Re: Mapping Load from Resident - field not found error

Thank you Dilip;  it drove me nuts; thanks for your time

dilipranjith
Honored Contributor

Re: Mapping Load from Resident - field not found error

no problem happens to everyone.