contains in expression

[rafael5958]

I need an expression that retuns true if the selected value is in a column. Example:

TABLE_A:
LOAD * INLINE [

    ID1

    AAA
    BBB
    CCC
    DDD

];

TABLE_B:
LOAD * INLINE [

    ID2

    AAA
    HHH
    KKK
    RRR
];

In Table_B if I click in AAA it should return true in a textbox. Tried to use FieldIndex, match, wildmatch, but it doesnt work, only when I select AAA in both tables, but Table_A cant be selected, it must search in all table.

Thanks.

[Taoufiq_Zarra · Accepted solution]

I don't know if I understood correctly, but here's a proposition...

Text Object Script :

=if(match(GetFieldSelections(ID2),$(=concat(chr(39)&ID1&chr(39),',')))>0,'True','False')

output :

[Vegar]

Maybe you can try something like this:

=if(Count({<ID1=P(ID2) >} ID1) > 0, 'True', 'False')