topic Field not found error with load statement in QlikView

Field not found error with load statement

kinjal1645 — Wed, 25 Nov 2020 16:16:04 GMT

Hello,

I am getting error for below script:

--> script

Table1:

SQL SELECT

FIELD_A,

FIELD_B,

FIELD_C

FROM .. ;

Table2:

LOAD FIELD_A,

Subfield(FIELD_C, '#', 1) as temp1;

SubField(FIELD_C, '#', 2) as temp2;

LOAD FIELD_A,

Subfield(FIELD_C, '$') as temp3;

LOAD FIELD_A, FIELD_C

Resident Table1;

-->error

Field not found - <FIELD_C>

LOAD FIELD_A, FIELD_C

Resident Table1;

Can someone help me with this?

Thank you

Kinjal

Re: Field not found error with load statement

sudhirpkuwar — Fri, 15 Jun 2018 05:32:51 GMT

Try this

Table2:

LOAD *,

Subfield(FIELD_C, '#', 1) as temp1;

SubField(FIELD_C, '#', 2) as temp2;

//LOAD FIELD_A,

Subfield(FIELD_C, '$', 1) as temp3;

LOAD trace_id,

SubField(metainfo, '$') as Properties;

//LOAD FIELD_A, FIELD_C

Resident Table1;

Re: Field not found error with load statement

Anil_Babu_Samineni — Fri, 15 Jun 2018 05:57:55 GMT

If you look - You are doing Preceding load concept. So, I may look this way where you stuck

Table2:

LOAD FIELD_A,

Subfield(FIELD_C, '#', 1) as temp1;

SubField(FIELD_C, '#', 2) as temp2;

LOAD FIELD_A, FIELD_C

Subfield(FIELD_C, '$', 1) as temp3;

LOAD trace_id,

SubField(metainfo, '$') as Properties; // Where is the FIELD_C comes from? If you add like in RED, Your problem solvs

LOAD FIELD_A, FIELD_C

Resident Table1;

FYI - https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Scripting/preceding-load.htm

Re: Field not found error with load statement

Anonymous — Fri, 15 Jun 2018 09:34:19 GMT

ur preceding load throw error.. so ...insted of using preceding load 3 time you can write this way..

Table1:

SQL SELECT

FIELD_A,

FIELD_B,

FIELD_C

FROM .. ;

Table2:

LOAD FIELD_A,

Subfield(FIELD_C, '-', -1) as temp1,

SubField(FIELD_C, '-', -2) as temp2,

Subfield(FIELD_C, '-', 1) as temp3;

LOAD FIELD_A, FIELD_C

Resident Table1;