
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Field not Found Error
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
- Tags:
- qlikview_scripting
- « Previous Replies
-
- 1
- 2
- Next Replies »
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
use concatenate or a join between two or more tables (according to your logic)
After that tables became one, you may load a field


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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().

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Luwen
can you post your code for me to review?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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

- « Previous Replies
-
- 1
- 2
- Next Replies »