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.

Pragati11's avatar
Pragati11
Super User
6 years ago

Hi labuser1235 ,

 

I don't think without edit query transactions if you can get a new table.

If in case you don't want a new table, you can use MATRIX visual,

On matrix visual, you can have TID on Row section, FName under Column section and your summarised metric under VALUE section.

 

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

 

Thanks,

Pragati