Case 899 How to Flag 2 company from database ?

[paulyeo11]

Hi Sir

I have below load script for Flag 2 company :-

VTIGER:
LOAD COY_RAW
FROM
VTIGER_.xlsx
(ooxml, embedded labels, table is TA);

sales_G:
LOAD *,
COY_RAW as KeyAcc_CoyName
resident VTIGER;

tmpZOHO:
LOAD
[Full Name] AS LAST_NAME,
[Company Name],
UPPER([Company Name]) AS COY_NAME
FROM
ZOHO.csv
(txt, codepage is 1252, embedded labels, delimiter is ',', msq, header is 1 lines);

sales_G:
LOAD *,
COY_NAME as chkCOY_NAME
resident tmpZOHO;

Concatenate (tmpZOHO)
LOAD
COY_NAME,LAST_NAME
Resident
VTIGER
where
not Exists(chkCOY_NAME, COY_NAME)
;

I get error msg from those script in blue color :-

Field not found - <COY_NAME>
Concatenate (tmpZOHO)
LOAD
COY_NAME,LAST_NAME
Resident
VTIGER
where
not Exists(chkCOY_NAME, COY_NAME)

[rubenmarin · Accepted solution]

Hi, if you do:

VTIGER:
LOAD COY_RAW

Then VTIGER table only has COY_RAW field.

If after that you try

LOAD
COY_NAME,LAST_NAME
Resident
VTIGER

It returns an error because those fields are not loaded in VTIGER table.

PFA.

[paulyeo11]

Hi Sir

Wow you are good. 

Thank you very much for your help , it work fine. 

Paul

[paulyeo11]

Hi Sir

https://community.qlik.com/t5/QlikView-Scripting/Case-897-Why-section-access-only-work-when-reload-o...

I have one more issue seek your help on above link.

Can you pls advise me

Paul