Forum Discussion

elettra84's avatar
elettra84
New Member
6 years ago
Solved

Handling tag data in a table

Hi all, I went through the posts but couldn't find an answer to the following question (apologies if I missed it). I have a table that has a field containing a list of tags (I can format this strin...
Need Help
  • v-eachen-msft's avatar
    v-eachen-msft
    6 years ago

    Hi elettra84 ,

     

    You could open query editor and unpivot the tag columns to get an extra column. Then pivot this column to get IDs without aggregation and remove blank tags.

    Here is my test file for your reference.

     

v-eachen-msft's avatar
v-eachen-msft
Community Support
6 years ago

Hi elettra84 ,

 

You could open query editor and unpivot the tag columns to get an extra column. Then pivot this column to get IDs without aggregation and remove blank tags.

Here is my test file for your reference.