Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

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

Rename field names with other rows

oliviercz
6 - Meteoroid

Hello, my input data is this :

input.jpg

and I would like to rename the field with the concatenation the first row and the field names (and keeping only the year from the field name note the number afterward)

So my desired output would be this :

output.jpg

Thanks

2 REPLIES 2
pdave87
11 - Bolide

hi, 

 

@oliviercz yes, this can be achieved by following below steps. Tested workflow is attached for your review.

 

 

pdave87_0-1634552670184.png

pdave87_1-1634552693654.png

 

AngelosPachis
16 - Nebula

Hi @oliviercz ,

 

Here's one way you can do it. You should first isolate the first record of data, that contains your month names. Then if you transpose that record, you can form you column headers as YYYY + Month. Then with a dynamic rename tool, you can rename each column in your dataset

 

AngelosPachis_0-1634552853557.png

 

Hope that helps, let me know if you have any question on the workflow.

 

Cheers,

Angelos

 

Labels