Forum Discussion

Sopanda's avatar
Sopanda
Frequent Visitor
7 years ago

Pulling Data from Tags Field Azure Dev Ops

We are using Azure Dev Ops as our source and pulling it into Power BI.

 

Our work items contains a bunch of tags in a specific schema.

 

I want to be able to search if a work item contains a specific word in the tags field (i.e. Animal:XXX; House:XXXXX; )

 

So i want it to look for House: and than pull the House data into a new column. Is this possible?

General Comment
Need Help
Tips and Tricks
Tutorial Requests

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Sopanda  I am not following you. Do you like to match and catch a row from 2 different tables or all in the same table? Please share your sample data replicate to be able to help you better

    Sepehr07

    • Sopanda's avatar
      Sopanda
      Frequent Visitor
      7 years ago

      Thanks for replying so quick. 


      Here's a table and the outcome of what I want to achieve. 

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        If I got you right, it it a really simple problem:

        in Power Query you can easily use split by delimeter, then choose by ; on the delimeter type and finally you will have 3 different columns as you wish. You can change the column headers as your wish.

        hope it helpI hope this helps.

         

         

         

        If it does, please Mark as a solution.
        I also appreciate Kudos.