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
Peter_Cammaert
Partner - Champion III
Partner - Champion III

It would be good if you could tell us where exactly in your script the error message is generated. Which LOAD statement generates the error (and which field isn't found)?

AH
Creator III
Creator III
Author


Hi Peter,

Thanks for your reply. Soory i forgot to attach the script error snapshot.

Thanks,

Shan

engishfaque
Specialist III
Specialist III

Dear Ahmed100,

Kindly add ItemID in your preceding load, as mentioned below:

UPS_Shipped_Orders:

Load *, ItemID, ...

Kind regards,

Ishfaque Ahmed

AH
Creator III
Creator III
Author

Hi Ishfaque,

Thanks for your reply. I think ItemID is already there in the table. Correct me if i am wrong.

Thanks,

Shan

engishfaque
Specialist III
Specialist III

Dear Ahmed100,

Yes It's. But you are concatenating ItemID with other fields.

Add and check this line in your script,

Load *, ItemID, etc...;

Or share us your script and data file.

Kind regards,

Ishfaque Ahmed

AH
Creator III
Creator III
Author

Hi Ishfaque,

Thanks for your reply. Adding that in the script is giving me bunch of errors while reloading script. Did you take a look the LinkTable snapshot i attached earlier in the post?

Thanks,

Shan

engishfaque
Specialist III
Specialist III

Dear Ahmed100,

Is this possible to share your sample data file and script?

Kind regards,

Ishfaque Ahmed

Peter_Cammaert
Partner - Champion III
Partner - Champion III

Hi Ahmed100

Using just the information you provided in this thread, it's close to impossible to figure out what goes wrong in your script. Please post your entire script as Ishfaque requested.

Peter

AH
Creator III
Creator III
Author

Hi Ishfaque,

Please see your email. Let me know if you have any questions.

Thanks,

Shan