Forum Discussion

analystict's avatar
analystict
Icon for Helper I rankHelper I
8 years ago
Solved

Wildcard matching & returning a value

Hi,   Basically, I have a table named "people" with different records and a record named "ref"     id | country | age | ref 1 | China | 25 | a32f134fnaq?ref=site 2 | USA | 22 | a32f1...
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    analystict

     

    Try this one

     

    ref_name =
MINX (
    FILTER ( refs, SEARCH ( refs[ ref], People[ ref], 1, 0 ) > 0 ),
    [ name ]
)
Zubair_Muhammad's avatar
Zubair_Muhammad
Icon for Community Champion rankCommunity Champion
8 years ago

analystict

 

Try this one

 

ref_name =
MINX (
    FILTER ( refs, SEARCH ( refs[ ref], People[ ref], 1, 0 ) > 0 ),
    [ name ]
)
analystict's avatar
analystict
Icon for Helper I rankHelper I
8 years ago

Thanks a lot! Working great.