Discussion Board for collaboration on QlikView Scripting.
Hi, Sorry, I have lots of SQL experience but new to Qlik.
I have a script that loads from an odbc connection and I want to then use it in a load using resident.
Even the simple one below gives a script error as
Field not found - <fwk_num>
What am I doing wrong?
I tried the unqualify command that I found when looking up these type of errors but it too didnt work.
I am using the free trial version at the minute as my company is still in the process of buying licences.
Is it a restriction of the trial version?
Script after the ODBC connect string is shown below.
Thanks for reading.
store trade_data into 201422_trade.qvd;
Go to Solution.
with this I get a field not found error on my oracle db
L.COD_LOG as cod_logalias
FROM DWH_DL.U002_LOG L
change to uppercase the field
oracle send an uppercase field
in the load you use a lowercase --> field not found
your LOAD looks all right - did you close it off with a semicolon like the others?
check this script first
use table viewer CTRL+T to see records and fields of trade_trans
Yeah, That works. But then I had already seen data loaded and the execution progress window shows data rows being processed.
I have tried using an alias but that fails to find it too!
Annoying as it must be something really silly I'm missing.
You dont have to close down the odbc connection before using resident do you?
I think you might be experiencing auto-concatenate problems. If tables have the same fields then they will be merged together.
Try again but this time use
fwk_num as fwk_num_tmp
no problem with odbc
I think auto concat as David suggests, use David post or this
Sorry guys, Neither noconcatenate or the alias on the load from resident make any difference.
As you are loading same field in Resident load, I would recommend using preceding load.