Set the field of a table, as the join of two different fields of different tables

[#1]

Hello,

I have three charts like this:

I want to join the field 1 and the field 2 with the name Field 3, so the Qlikview automatically joins them. Is this possible?

[alexandros17]

Sorry but the problem is not clear to me, could you please sent an example ?

[datanibbler]

Hi,

QlikView automatically links tables on fields that have the same name. You can use the AS option in any LOAD statement to make the field_names match. Would that help you`?

[#4]

It's a simple thing but I don't know if it can be done and I don't fine anything.

Imagine you have:

Table1:

     Name,

     Surname,

     Things_table1

     Data_table1

Table2:

     Surname,

     Things_table2

     Data_table2

And this two tables are united by the surname.

Then I have

Table 3:

     Things_table3

     Data_table3

Things_table3 has the same data as the join of things_table1 and things_table2 (Things_table1 and Things_table2 are in Things_table3, but are different).

Te thing is that I can't set the same name to all Things, because then Qlikview automatically relates me Table1 and Table2 by Things, but I don't want to. I only want to to create another variable or table which relates the join of Things_table1 and Things_table2 with Things_table3. So if I select an item of Things_table3 it shows me with which Table is related (table1 or table2)

[ramoncova06 · Accepted solution]

you can, though you first have to join table 1 and table 2 and then create the Things_table3 field

Table1:

     Name,

     Surname,

     Things_table1

     Data_table1

join (Table1)

Table2:

     Surname,

     Things_table2

     Data_table2

     Temp

     Name,

     Surname,

     Things_table1,

      Things_table2,

     Things_table1&Things_table2 as Things_table3

     resident Table1

join (Temp)

Table 3:

     Things_table3

     Data_table3

[sgrice]

Join all  3 table with a Composite key using the Fields from Each if Fields are in same order and have same value then autonumberhash256 will create same key.

See Below

Table1:

    'Table1' as SOURCE,

     Name,

     Surname,

     Things_table1

     Data_table1

     autonumberHash256(Things_table1,Data_table1) as FIND_DATA

Concatenate (Table1)

   'Table2' as SOURCE,

     Surname,

     Things_table2

     Data_table2

     autonumberHash256(Things_table2,Data_table2) as FIND_DATA

And this two tables are united by the surname.

Then I have

Table 3:

     Things_table3

     Data_table3

     autonumberHash256(Things_table3,Data_table3) as FIND_DATA

[#7]

What's temp?

[#8]

The thing is that I don't want to join table 1 and 2 because they have different data that I want to extract

[#9]

I don't want to join the first and second table because I only want them to be related for the Surname. If I create the field  FIND_DATA it will join them also with this field, doesn't it?

[sgrice]

Do not think of Concatenating has JOINING. in Qlikview it just means there referenced by the same name. All the fields other than surname can and should be different.