Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Search text from one table and match from another table add column

Hi,

 

Is it possible to do this with power bi: I have two tables, 'ToteutetutChanget' and 'Data'.

 

I need  to search Values in ToteutetutChanget[Tiketti] from Data[Comment] and add column to Data table which includes the search string. Data[Comment]column contains free text and somewhere in the column row there is always the ticket number which to find.

Data[comment looks like this

 

ToteutetutChanget[Tiketti] (these are the search values, column row contains only the ticket id like this)

 

Need Help
  • Gabriel_Walkman's avatar
    Gabriel_Walkman
    4 years ago

    How about you split the comment column with delimiter of " ", extract as rows and filter to ones that include "REQ"?

     

    I don't get the need for the separate Tiketti column in this case. Then you could just create a relationship. Eli molemmista tauluista löytyy sit tiketti, niiden välille vaan relationship jos on tarvetta. 

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    The solution is often easier than you thought of. Thanks this is obviously the way to go 🙂

  • Gabriel_Walkman's avatar
    Gabriel_Walkman
    Icon for Continued Contributor rankContinued Contributor
    4 years ago

    How about you split the comment column with delimiter of " ", extract as rows and filter to ones that include "REQ"?

     

    I don't get the need for the separate Tiketti column in this case. Then you could just create a relationship. Eli molemmista tauluista löytyy sit tiketti, niiden välille vaan relationship jos on tarvetta.