Forum Discussion

aridavid's avatar
aridavid
Frequent Visitor
5 years ago
Solved

Summarize a table by rows from multiple columns

Hello,   I have the following use case, where a table contains:   Table_Savings Product1_LongTerm Product1_ShortTerm Product2_LongTerm Product2_ShortTerm Product3_LongTerm Product3_Short...
Need Help
Tips and Tricks
  • ryan_mayu's avatar
    ryan_mayu
    5 years ago

    aridavid 

    i imported the data as you shared and did data transform in the PQ editor.

    you can check the source and followed the steps I did.

aridavid's avatar
aridavid
Frequent Visitor
5 years ago

Thanks ryan_mayu this is helpful, the problem I have is that my data is not tabulated as per te attributes column you shared. I have em' in separate columns, the tricky part is to actually get to have them in the way you plot them, like all in one single column.

 

I was thinking maybe transforming the table at a query level would be 'easier'.

  • ryan_mayu's avatar
    ryan_mayu
    Super User
    5 years ago

    aridavid 

    i imported the data as you shared and did data transform in the PQ editor.

    you can check the source and followed the steps I did.