We're excited to announce that we'll be partnering with Credly starting October 19th - see what this means and read the announcement blog here!

Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Column Name Change

sgaryali
6 - Meteoroid

I want to change the name of B column i.e. - Balance to end M-1 to column G i.e. - January

How can that be done attaching file for reference.

4 REPLIES 4
Nanoq
8 - Asteroid

Hello Sgaryali
Just to be sure; you need the new name to be whatever is in column G, and value of that column should be whatever is currently in column B?

sgaryali
6 - Meteoroid

Hi @Nanoq 

Yes, exactly

Christina_Hurrell
11 - Bolide

You can do this with the Dynamic Rename tool.

Christina_Hurrell_0-1634206907553.png

 

Nanoq
8 - Asteroid

I think you will have to use a cross tab tool, select all columns as crosstab, EXCEPT [balance to end M-1] and [Month1]
select [Month1] as your new headers and [balance to end M-1] as your values. you can choose sum as the aggregation methodCapture.PNG

Labels