Solved: Re: Table viewer issue - Qlik Community

Report Inappropriate Content · ‎2016-03-30

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?

martinpohl · ‎2016-03-30

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

View solution in original post

Chanty4u · ‎2016-03-30

can u share sample data?

or screen shot what ur getting exctly?

buzzy996 · ‎2016-03-30

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

Report Inappropriate Content · ‎2016-03-30

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.

buzzy996 · ‎2016-03-30

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

andrespa · ‎2016-03-30

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

satishkurra · ‎2016-03-30

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

LOAD

Brand as BrandNew....

LOAD

Brand .....

Chanty4u · ‎2016-03-30

try to rename ur fieldname

load *,

....

brand as Newbrand

......

from datasource;

Report Inappropriate Content · ‎2016-03-30

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.

Chanty4u · ‎2016-03-30

u canc reate a concatenated key

between claim code and serialnum.