# Renaming Columns

**URL:** <https://forum.kx.com/t/renaming-columns/9135>\
**Category:** Community Support\
**Tags:** kdb-and-q\
**Created:** [October 7, 2014, 4:33pm UTC](https://forum.kx.com/t/renaming-columns/9135 "2014-10-07T16:33:00Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Jake1](https://avatars.discourse-cdn.com/v4/letter/j/73ab20/32.png) [@Jake1](https://forum.kx.com/u/Jake1)\
**Post date:** [October 7, 2014, 4:33pm UTC](https://forum.kx.com/t/renaming-columns/9135/1 "2014-10-07T16:33:00Z")

</div>

I’m looking for a way to rename many columns all at once. For example:

&nbsp;

t:(a:til 5;b:0;c:3)

Let’s say I want to add “US” to all coumns, I know I can use xcol

&nbsp;

t:`USa`USb`USc xcol t

&nbsp;

But what if I have dozens of columns?

&nbsp;

Is there a way to simply say, "Add “US” to the front of all column names?

&nbsp;

Thanks

&nbsp;

&nbsp;

---

<div class="post-metadata">

**Author:** ![Glen\_Smith](https://avatars.discourse-cdn.com/v4/letter/g/5daacb/32.png) [@Glen\_Smith](https://forum.kx.com/u/Glen_Smith)\
**Post date:** [October 7, 2014, 4:37pm UTC](https://forum.kx.com/t/renaming-columns/9135/2 "2014-10-07T16:37:00Z")

</div>

Hey Jake,

How about this.

t:(`$(“US”),/:string cols t) xcol t

---

<div class="post-metadata">

**Author:** ![Jake1](https://avatars.discourse-cdn.com/v4/letter/j/73ab20/32.png) [@Jake1](https://forum.kx.com/u/Jake1)\
**Post date:** [October 7, 2014, 4:40pm UTC](https://forum.kx.com/t/renaming-columns/9135/3 "2014-10-07T16:40:00Z")

</div>

Perfect.

&nbsp;

Thank you