topic Resident field in QlikView

Resident field

ch_riadh — Sat, 17 Sep 2016 16:09:21 GMT

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

Re: Resident field

maxgro — Sat, 17 Sep 2016 16:20:21 GMT

concatenate is for table not for field

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

Re: Resident field

Anonymous — Sat, 17 Sep 2016 16:32:17 GMT

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.

Re: Resident field

ch_riadh — Sat, 17 Sep 2016 17:06:18 GMT

‌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

Re: Resident field

ch_riadh — Sat, 17 Sep 2016 17:07:02 GMT

‌yes but it will give me a loop.

Re: Resident field

maxgro — Sat, 17 Sep 2016 17:19:24 GMT

please post a .qvw

Re: Resident field

el_aprendiz111 — Sat, 17 Sep 2016 18:18:41 GMT

Hello,

I send example:

Re: Resident field

vinieme12 — Sat, 17 Sep 2016 19:19:50 GMT

please post sample app/data

Re: Resident field

Anonymous — Sat, 17 Sep 2016 19:34:50 GMT

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!!

Re: Resident field

ch_riadh — Sat, 17 Sep 2016 20:59:00 GMT

‌hi guys

it is very simple.

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

Re: Resident field

ch_riadh — Sat, 17 Sep 2016 21:43:03 GMT

i found the solution.

join 2 tables in temp_table, and then use the resident table so you can use the 2 table and make calculation in the editor

thanks