Field not Found Error

[#1]

Hello,

I loaded data from different tables of an Access file, and structured them in different tabs in Qlikview. Now I want to write a function in a Load statement in one tab, which uses a field in another tab.  Then there's the error message 'field not found'.  How can I set up the connection between 2 tabs? I appreciate any help from you.

Luwen

[alexandros17]

use concatenate or a join between two or more tables (according to your logic)

After that tables became one, you may load a field

[fdelacal]

always you need connection 2 tables by the same NAMEFIELD

you can t connect if in tabla1 is FIELDA and in table2 is FIELDB

You need to rename with AS one of this fields.

Regards

[jsingh71]

If you are using field from second tab in first tab then definately it will show this error message.

Always remember use only those fields which you already loaded.

--jai

[#5]

Hi Luwen,

you have two ways: it can carry out a resident load table A as mapping and apply the mapping in another table or you can use the Lookup function.

Best regards

[sudeepkm]

As others have suggested and this is how QlikView works.

if you are loading a field already loaded into QlikView then you need to use the reference code just after the original load script of the source field.(it can be in another tab after the original tab)

Then you can use Resident load from that table or you can use ApplyMap is the first table is Mapping loaded or you can use lookup().

[#7]

Hi, Alessandro! Thanks for your reply. I tried to join (or concatenate) the tables, but there's still error message pop-up, saying there's mistake when opening the data (the former table I created), the system could not find the data.  Do you maybe know what the problem is?

[#8]

Thank you, Claudio!  I tried your solutions as well, but the same error message popped up as I joined the tables: the system could not find the data (the tables that I created). Do you know what the problem is?

[#9]

Hi Luwen

can you post your code for me to review?

[#10]

Hi, Claudio!

Attached is the code. It's a bit messy now, since I tried every method to associate the tables that I have imported... but still the system can not find the data...

thank you.

Luwen