topic Re: Linking table problem in QlikView

Linking table problem

AH — Sun, 18 Jan 2015 17:53:14 GMT

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

Re: Linking table problem

Peter_Cammaert — Sun, 18 Jan 2015 18:12:08 GMT

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)?

Re: Linking table problem

AH — Sun, 18 Jan 2015 18:20:16 GMT

Hi Peter,

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

Thanks,

Shan

Re: Linking table problem

engishfaque — Sun, 18 Jan 2015 18:42:10 GMT

Dear Ahmed100,

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

UPS_Shipped_Orders:

Load *, ItemID, ...

Kind regards,

Ishfaque Ahmed

Re: Linking table problem

AH — Sun, 18 Jan 2015 19:09:06 GMT

Hi Ishfaque,

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

Thanks,

Shan

Re: Linking table problem

engishfaque — Sun, 18 Jan 2015 19:25:24 GMT

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

Re: Linking table problem

AH — Sun, 18 Jan 2015 19:34:02 GMT

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

Re: Linking table problem

engishfaque — Sun, 18 Jan 2015 19:42:25 GMT

Dear Ahmed100,

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

Kind regards,

Ishfaque Ahmed

Re: Linking table problem

Peter_Cammaert — Sun, 18 Jan 2015 20:05:01 GMT

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

Re: Linking table problem

AH — Sun, 18 Jan 2015 21:13:43 GMT

Hi Ishfaque,

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

Thanks,

Shan

Re: Linking table problem

engishfaque — Mon, 19 Jan 2015 06:26:46 GMT

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

Re: Linking table problem

AH — Mon, 19 Jan 2015 16:33:20 GMT

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

Re: Linking table problem

engishfaque — Mon, 19 Jan 2015 16:40:27 GMT

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