Forum Discussion

abelrmg's avatar
abelrmg
Helper II
9 years ago
Solved

Merge rows

Hi,   I have this data   How can i merge de rows and obtain one row with this structure: idticket fecharegistro1 fecharegistro2 fecharegistro5 fecharegistro7 1219 26/11/2015 30...
Need Help
  • v-sihou-msft's avatar
    v-sihou-msft
    9 years ago

    abelrmg

     

    You just need to create a custom column to append "Date" with estatus, then directly pivot on that column. See my sample below:

     

     

    Regards,

abelrmg's avatar
abelrmg
Helper II
9 years ago

Hi MarcelBeug the query send this error

 

Expression.Error: The column 'idCliente' of the table wasn't found.
Details:
idCliente

 

Regards

v-sihou-msft's avatar
v-sihou-msft
Microsoft Employee
9 years ago

abelrmg

 

You just need to create a custom column to append "Date" with estatus, then directly pivot on that column. See my sample below:

 

 

Regards,