Resident field

[ch_riadh]

HEllo

i have

table1:

field 1, field2

and

table 2

field 3 , field 4

i want to create a concatinate field To link it with another field5 in a table3.

table1.field1 & table2.field3.

‌i think i have to use the resident ! Right ?

thanks

[maxgro]

concatenate is for table not for field

could you explain the expected output? or post a .qvw with an example?

[Anonymous]

Split the key in Table 3  as per Table1 .Field1 and  Table2.Field3 if they are completely different ID's and rename them exactly as per Field1 and Filed3.  As per QlikView associative property, they will have association with Table1 and Table2.

If you are looking for completely different scenario, upload sample QVW.

[ch_riadh]

‌concatenate mean make a composite key

field1 '001', fiel2 'Abc'

field1 & '-' & field2  as key

the key   ---->     001-abc

but the fields are i a differante tables

[ch_riadh]

‌yes but it will give me a loop.

[maxgro]

please post a .qvw

[el_aprendiz111]

Hello,

I send example:

[vinieme12]

please post sample app/data

[Anonymous]

It will not form a loop unless you have anything common between table1 and 2. Can you at least specify how did you do it with field names!!

[ch_riadh]

‌hi guys

it is very simple.

i Want to use a field resident in table1, in table2