topic Re: Table viewer issue in QlikView

Table viewer issue

Wed, 25 Nov 2020 16:16:04 GMT

I have two tables in my table viewer and it automatically created a link between them two fields with the same name. However, the tables are not linked that way. I have tried everything to delete the link and create the link the tables between the correct fields. What am I doing wrong?

Re: Table viewer issue

Chanty4u — Wed, 30 Mar 2016 15:41:31 GMT

can u share sample data?

or screen shot what ur getting exctly?

Re: Table viewer issue

buzzy996 — Wed, 30 Mar 2016 15:49:05 GMT

can u copy ur script on to new document and reload ? and see.

Re: Table viewer issue

Wed, 30 Mar 2016 15:49:12 GMT

Brand is not a valid link between the two tables. I would like to delete this link and create a new one between two different fields.

Re: Table viewer issue

buzzy996 — Wed, 30 Mar 2016 16:13:04 GMT

are u tried to rename of the brand field from any one of the table from script and do joining accordingly ur needs?

Re: Table viewer issue

andrespa — Wed, 30 Mar 2016 16:13:58 GMT

You need to rename one of the Brand field or use a QUALIFY Statement before the table load.

i.e:

QUALIFY *;

TABLE1:

LOAD*

FROM[YourPath]

TABLE2:

LOAD*

FROM[YourPath]

That way all the fields will have a prefix with the table name (i.e. TABLE1.Brand and TABLE2.Brand)

And finally to link the tables you must put the same name in both tables of the field for you want to link.

Hope it helps,

Andrés

Re: Table viewer issue

satishkurra — Wed, 30 Mar 2016 16:17:04 GMT

1 of the table rename Brand as BrandNew in load script and reload it

LOAD

Brand as BrandNew....

LOAD

Brand .....

Re: Table viewer issue

Chanty4u — Wed, 30 Mar 2016 16:20:07 GMT

try to rename ur fieldname

load *,

....

brand as Newbrand

......

from datasource;

Re: Table viewer issue

Wed, 30 Mar 2016 17:25:07 GMT

So I renamed one of the "Brand" fields to NewBrand like Chanty 4u suggested. Now how do I create the link between the two fields that should be linked? It doesn't let me drag and drop.

Re: Table viewer issue

Chanty4u — Wed, 30 Mar 2016 17:54:26 GMT

u canc reate a concatenated key

between claim code and serialnum.

Re: Table viewer issue

Wed, 30 Mar 2016 18:24:12 GMT

I figured it out. In the script editor, I needed to change the field names by using the "as newfieldname" in the script editor to be the same name.

Re: Table viewer issue

martinpohl — Wed, 30 Mar 2016 18:43:55 GMT

you are right.

QlikView create a links between same field name(s)

If you don't want that they be linked, rename them with "as" to different names,

if the fields you want to link have different names you have to rename at least one like the field from first table.

Also, QlikView wants only one linked field between tables, so if a unique identification is only possible by many fields, you have to combine them with "&" to one single field.

In one table you should use the combines filed with single information for select.

Regards

Re: Table viewer issue

Wed, 30 Mar 2016 18:54:47 GMT

Thanks for the extra tidbit about linking multiple fields. I am sure I will run into that in the future.