Forum Discussion

Kasiop's avatar
Kasiop
Helper II
4 years ago
Solved

Substring and Approximative Match

Hi,   I have an issue and I am really stuck here, let me explain it: Currently I have 2 sources and no exact matching.   What do I want to achieve? I want to match SOURCE1.bucket/source w...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    4 years ago

    Hi,

    This calculated column formula works

    Column = FIRSTNONBLANK(FILTER(VALUES(Buckets[BUCKET]),SEARCH(Buckets[BUCKET],Data[FULL_DATABASE_NAME],1,0)),1)

Kasiop's avatar
Kasiop
Helper II
4 years ago

Below what I could give as data, I hope it will be useful.

 

Thanks,

 

SOURCE 1

FULL_DATABASE_NAMEBUCKET /SOURCEWHAT I WANT (and I don't have)
landingconsumabledbprdaeranpillaeranpillaera
landingconsumabledbprdaerap6rsaerap6rsaera
landingconsumabledbprdaerap5opaerap5opaera
landingconsumabledbprdaerap3traerap3traera
landingconsumabledbprdaerap1teaerap1teaera
landingconsumabledbprdaeraplbouaeraplbouaera
landingconsumabledbprdaerasxyrlaerasxyrlaera
landingconsumabledbprdtelonip1eetelonip1eeteloni
landingconsumabledbprdtelanosp3oktelanosp3oktelanos
landingconsumabledbprdtelanosp1trtelanosp1trtelanos
landingconsumabledbprdtelanossmdltelanossmdltelanos

 

SOURCE 2

BUCKET
aera
telanos
teloni

 

Ashish_Mathur's avatar
Ashish_Mathur
Super User
4 years ago

Hi,

This calculated column formula works

Column = FIRSTNONBLANK(FILTER(VALUES(Buckets[BUCKET]),SEARCH(Buckets[BUCKET],Data[FULL_DATABASE_NAME],1,0)),1)

  • Kasiop's avatar
    Kasiop
    Helper II
    4 years ago

    thanks a lot Ashish, your solution works!! 

     

    Many thanks to all of you ğŸ˜—!!!

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Super User
      4 years ago

      You are welcome.