Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
AH
Creator III
Creator III

Linking table problem

Hi,

I am having this problem with linking tables in my data model. After i reload the script its saying Field not found. I am attaching some snapshot from the script.

Could you please suggest me whats the mistake i am doing?

Really appreciate your help in advance.

Thanks,

Shan

12 Replies
engishfaque
Specialist III
Specialist III

Dear Ahmed100,

I have checked your file, even I created temporary files with limited number of fields with dummy data. It's working fine.

For testing purpose, you need to comment ItemID from UPS_Shipped_Orders and then recheck.

Your link table is fine there is no issue, but when it's going to Load ItemID then ItemID not found in particular table. It means you need to trace out your main table(s).

Kind regards,

Ishfaque Ahmed

AH
Creator III
Creator III
Author


Hi Ishfaque,

You want me to comment ItemID from the Linktable or from the main table of UPS_Shipped_Orders? Let me know.

Thanks,

Shan

engishfaque
Specialist III
Specialist III

Dear Ahmed100,

First:

ItemID comment from main table "UPS_Shipped_Orders", then check.

Second:

ItemID un-comment from main table "UPS_Shipped_Orders", and Comment ItemID from link table, then check.

Third:

ItemID comment from main table "UPS_Shipped_Orders" as well as link table.

Kind regards,

Ishfaque Ahmed