I have two tables with no relation want to link them

[zebhashmi]

please see the file attached.

by selecting a name from the field.  want to all related names

like if i will select a in KPI i will find c and d

and if i will select d it will show a

test:
load * Inline [
id, Name
1,a
2,b
3,c
4,d
];

test2:
Load * Inline [
R1,R2
1,3
1,4
2,3
]

Thanks in Advance

  Its not letting me attach qvf file

[Gysbert_Wassenaar · Accepted solution]

You can't select a value in a field that is a different selection in the same field. Well not without some magic that requires an extension. Instead select in one field called Name and see the possible values in the field NameLink.

test:
load * Inline [
id, Name
1,a
2,b
3,c
4,d
];

mapIdName:
MAPPING LOAD id, Name Resident test;

test2:
Load
*,
ApplyMap('mapIdName',R1) as Name1,
ApplyMap('mapIdName',R2) as Name2
Inline [
R1,R2
1,3
1,4
2,3
];

test3:
LOAD R2 as id, Name1 as NameLink Resident test2;
LOAD R1 as id, Name2 as NameLink Resident test2;

[zebhashmi]

Perfect Than you very much!