cancel
Showing results for 
Search instead for 
Did you mean: 

update column name in partitioned table

KB
New Contributor

I have a partitioned table t with columns date, class, nan. I want to update the column "nan" to "name".
I am trying this: `date`class`name xcol t

This is not working. 

Please help me out here guys:)

1 ACCEPTED SOLUTION

cillianreilly
New Contributor III

For operations on partitioned tables, please refer to dbmaint.q. In particular, the rename column should achieve what you're looking for.

https://github.com/KxSystems/kdb/blob/master/utils/dbmaint.md#renamecol

View solution in original post

1 REPLY 1

cillianreilly
New Contributor III

For operations on partitioned tables, please refer to dbmaint.q. In particular, the rename column should achieve what you're looking for.

https://github.com/KxSystems/kdb/blob/master/utils/dbmaint.md#renamecol