How to link two table with different field name

[#1]

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

[jagannalla]

TAB A:

Load fieldA as key,

          fieldA,fieldB;

TAB B:

Load fieldD as key,

          fieldC,fieldD;

Hope it helps you.

[#3]

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

TABA:

LOAD A as key,

         A,

         B

FROM data.xls

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

TABB:

Load D as key,

        C,

         D

FROM data.xls

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

Regards

Oronzo

[jagannalla]

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

[ekech_infomotio]

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

[#6]

Hello

this is my example

Regards

Oronzo

[ekech_infomotio]

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

[#8]

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

[jagannalla]

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.

[ekech_infomotio]

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