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

[#2]

Hi Luwen

try changing the expression "from" to "resident" in the mapping code that will work.

[#3]

Hey, Claudio!

I tried. But still 'field not found'......

Luwen

[sivarajs]

check which field name is throwing error by generating log file (document properties->Generate log file).

Check that field is exist in your database.

[#5]

Hey, Sivaraj!

Yes, the fields that I am interested in are there. Just when I want to link them to the other table, they can not be found, I don't know why...

Luwen

[#6 · Accepted solution]

Hi Lluwen

Try this

[#7]

Thank you very much, Claudio!

According to your logic I used ApplyMap() in both Year() functions, then it works!

Luwen