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 column

 

ref_Name =
VAR TextbeforeQM =
    LEFT (
        People[ ref],
        VAR mylen1 =
            FIND ( "?", People[ ref], 1, 0 )
        RETURN
            IF ( mylen1 = 0, LEN ( People[ ref] ), mylen1 - 1 )
    )
RETURN
    LOOKUPVALUE ( refs[ name ], refs[ ref], TextbeforeQM )
  • analystict's avatar
    analystict
    Icon for Helper I rankHelper I
    8 years ago

    Thanks for your reply :)

     

    Thing is, "?blablabla" is not always the case.

     

    It could also be ref=facebook?a32f134fnaq

    or

    a_id=a32f134fnaq

     

    Is there a workaround for that?

     

    Thanks :)

    • 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 ]
)