topic Re: How to link two table with different field name in QlikView

How to link two table with different field name

Fri, 27 Apr 2012 11:11:48 GMT

Hello to everybody,

I have 2 tables with different fields name

TAB A

field A	field B
X

and TAB B

field C	field D
	X

I would have a "link" trough field A and field D, so if I filter on TAB B,

I have the same filter on TAB A.

Is it possible to in QLIKVIEW ?

I hope I was clear,

Regards

Oronzo

How to link two table with different field name

jagannalla — Fri, 27 Apr 2012 11:16:26 GMT

TAB A:

Load fieldA as key,

fieldA,fieldB;

TAB B:

Load fieldD as key,

fieldC,fieldD;

Hope it helps you.

How to link two table with different field name

Fri, 27 Apr 2012 11:33:17 GMT

This is my load script but the filter doesn't works

TABA:

LOAD A as key,

FROM data.xls

(biff, embedded labels, table is work$);

TABB:

Load D as key,

FROM data.xls

(biff, embedded labels, table is work$);

Regards

Oronzo

How to link two table with different field name

jagannalla — Fri, 27 Apr 2012 11:37:18 GMT

If A and D field has same data values. If possible attach sample file.

Re: How to link two table with different field name

ekech_infomotio — Fri, 27 Apr 2012 11:40:51 GMT

Hi Oronzo,

without knowing your data, we only can guess where the real problem is. Load-statements look OK, but how do your Data look like? Do you have corressponding records in Field D to your Field A? Remember: QV works case-sensitive! Also make sure that you don't have blanks or other non-printable characters in your key-Fields.

regards,

Edgar

Re: How to link two table with different field name

Fri, 27 Apr 2012 12:41:00 GMT

Hello

this is my example

Regards

Oronzo

Re: How to link two table with different field name

ekech_infomotio — Fri, 27 Apr 2012 12:47:07 GMT

Hi Oronzo,

perhaps you should explain the meaning of the columns in your Excel-File. I guess your data from A should correspond to your data from F ????

regards,

Edgar

Re: How to link two table with different field name

Fri, 27 Apr 2012 13:02:36 GMT

I have reloaded my example,

I hope that it was more clear.

My target is to understand if two fields of two different tables that are named in a different way

can be connected one filter

Thanks

Oronzo

Re: How to link two table with different field name

jagannalla — Fri, 27 Apr 2012 13:08:58 GMT

Hello,

I've seen your data. But there is no common data b/w the fields. If there is common data in anyone of the field you can make a link, Otherwise we can't make link.

But one think i obsered, your are loading the data from one excel sheet only. Why your are loading the dataset in two tables. Ok any way i don't know why? If that is in the case you can use A as common field in both tables. For example,

Load A, B from work;

Load A,C,D from work;

- If i'm wrong, can you explain clearly how is your data.

Let me explain you when can it possible to link the data.

Table1:

A	B
1	b1
2	b2
3	b3

Table 2:

C	D
c1	1
c2	2
c3	3

- If your data looks like above, you can link two tables as we worked out previously.

Re: How to link two table with different field name

ekech_infomotio — Fri, 27 Apr 2012 13:17:06 GMT

Hi Oronzo,

I think you should differentiate between tables in your datamodel and table objects on your layout. No offense, but I'll strongly recommend you to read some of the very basics of Qlikview (manual, first steps). Otherwise you talk about banana and others understand "apples".

regards,

Edgar

Re: How to link two table with different field name

Fri, 27 Apr 2012 13:18:26 GMT

Jagan, I have understand I can link two different field only if they have the same value

Thank you

Oronzo

P.S. my example mattered little, I wanted to understand the concept

Re: How to link two table with different field name

Fri, 27 Apr 2012 13:24:11 GMT

My example mattered little, I wanted to understand the concept

My target is to understand if two fields of two different tables that are named in a different way

can be connected one filter

Thanks for your invaluable advice