Getting error in executing script

[Beginner_Qlik1]

Hi ,

Could someone help me rectify the error in following script(Attached screenshot).

Getting error 'ValueCategoryGlobal' and 'ProcessTypeGlobal' not found. Though these fields are present in residents tables Valuecategory and ProcessType respectively.

I am expecting Fields Value, ValueCategoryGlobal and ProcessTypeGlobal in temp table. But only field coming is Value.

[steeefan]

Your WHERE clause is only applied to the table ProcessType, not to Temp. You need to perform another LOAD on that table to filter on ValueCategoryGlobal.

Temp2:
NOCONCATENATE LOAD
  *
RESIDENT
  Temp
WHERE
  Match(ValueCategoryGlobal., ...);

[Beginner_Qlik1]

Hi Stefan,

I modified the script

But, still getting same error

• 

[jelzo_nl]

It seems like Temp contains fields that are used earlier in the script and is therefore concatenated to another table. 

Can you change the top row:

Temp:
LOAD _ProcessKey,

To:

Temp:
NoConcatenate
LOAD _ProcessKey,

[Beginner_Qlik1]

tried this also

But, still got same error

[BrunPierre]

@Beginner_Qlik1 The field in question is appended to the 'Value' Table, not the 'Temp'.

[Beginner_Qlik1]

@BrunPierre I intend to store the result of join of Value, ValueCategory, Process and ProcessType in Temp table. So my understanding is, if the field "ValueCategoryGlobal" is appended to Value, the result of joining all tables should get stored in table "Temp".

Please le me know what I am doing wrong here. 

[BrunPierre]

If my understanding is correct, then it would be something along these lines.

/*---Append ValueCategoryGlobal to Value---*/
Left Join(Value)
LOAD _ValueCategoryKey,
ValueCategoryGlobal

Resident ValueCategory;

/*---Append Process to Value---*/
Left Join(Value)
LOAD ...
Resident Process;

/*---Append ProcessType to Value---*/
Left Join(Value)
LOAD ...
Resident ProcessType

/*---Load relevant fields from Value into Temp ---*/
NoConcatenate
Temp:
LOAD ...
Resident Value
Where Match(ValueCategoryGlobal,'...','...','...');

DROP Table Value;
DROP Fields _ProcessKey,_ProcessTypeKey, ValueCategoryKey from Temp;

[Lech_Miszkiewicz]

Myt assumption is that you may have used "Temp" table names somewhere earlier in your load  or binary hence the one you are trying to create may have suffix like Temp-1 and your resident load cannot load from it. Try and rename Temp to different table name.

cheers

[SunilChauhan]

replace  with 

Left Join(Value)
Load _ValueCategoryKey,
ValueCategoryGlobal,
1 as junk
resident ValueCategory;