Discussion Board for collaboration on QlikView Scripting.
I have following data load script with exits command but It does not execute with an error message. pls correct me
det_debt_code AS DEBTOR_CODE,
trunc(det_ref_date) as Tran_dat,
trunc(det_risk_date) as Risk_dat,
det_hc_amt as Amount,
det_ref_c as Ref_c,
det_ref_2 as Ref_no,
det_txntype as TXN_type
det_txntype as TXN_type,
I want to load data from 2nd script where Ref_c matches with Ref_c of 1st script
Go to Solution.
load only the 1st table
and then check field names
Sometimes Oracle changes every field to uppercase so maybe the name is REF_C and not Ref_c
QlikView is translating this as the same load.
Just put a table name before the 2nd load :
and drop the 1st table when done.
is Ref_c unique?
Still I get the error massge below
Field not found - <Ref_c>
Try Upper case
You are right