Forum Discussion

labuser1235's avatar
labuser1235
Helper IV
6 years ago
Solved

Pivot creates duplicate values

Hi All,   I am trying to create a pivot for different types in a column. However, it creates multiple TIDs based because of the pivot.    I am aware that I can use fill up or fill down so that I ...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi labuser1235 ,

     

    Remove the FID column and pivot Fname column with Fdata as value column should work.

     

    Best Regards,

    Jay

     

    Community Support Team _ Jay Wang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

labuser1235's avatar
labuser1235
Helper IV
6 years ago

Pragati11 I donot want to use matrix visual... I would like the output to get achieved in table visual as I am also clubing it with another data from another tables. 

 

I would like to get that achieved as an output with the help of transformaitons using power query or calculated columns,so that I can use in table visual.

Pragati11's avatar
Pragati11
Super User
6 years ago

Hi labuser1235 ,

 

In that case try replacing null values in TID column with a value like "Unknown ID" or "ID Missing".

Then try the usual pivot steps in query editor.

 

If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂

 

Thanks,

Pragati