Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
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)

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper 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)

Anonymous's avatar
Anonymous
Not applicable
4 years ago

thanks a lot Ashish, your solution works!! 

 

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

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    4 years ago

    You are welcome.