Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
paulyeo11
Master
Master

Case 899 How to Flag 2 company from database ?

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)

1 Solution

Accepted Solutions
rubenmarin

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.

View solution in original post

3 Replies
rubenmarin

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.

View solution in original post

paulyeo11
Master
Master
Author

Hi Sir

Wow you are good. 

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

Paul

paulyeo11
Master
Master
Author

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