Forum Discussion
How to remove duplicate records
I connected to Cassandra DB and get the Data using API call, able to create the table. However, wanted to know how to remove the duplicate records. DateTime MessageID GatewayID Name Sensor...
The data is avaliable as Name value pair in the columns, please check the data again for more clarity.
ImkeF
Community Champion
Community ChampionIn order to achieve what you've showed you don't have to remove duplicates, but to pivot your data on a pair of columns. I've described the technique here:
http://www.thebiccountant.com/2015/08/12/how-to-pivot-multiple-measurescolumns-in-power-query/
Pls let me know if you need help implementing this.