Dynamically column names

[Zaid]

Hi All,

I have got two data sets, one having the score of students of current year and the other having the score of previous year. I have joined the two datasets and the data looks like this:

Name	Score_Current Year	Year	Right_Name	Score_Previous Year	Year
John	76	2018	John	68	2019
Mike	77	2018	Mike	75	2019
Anthony	85	2018	Anthony	89	2019

I was wondering if there is any way, we can change the name of the column "Score_Current Year" and "Score_Previous Year" with the respective values in the Year column. For example, Score_Current Year should be Score 2018 and Score_Previous Year should be Score 2019. And this should be dynamic.

Thanks

Zaid 

[jamielaird · Accepted solution]

Hi @Zaid ,

There are a few ways you could approach this. Here's one way:

Workflow attached.

-----

If I've answered your question please consider marking this solution as accepted. Thank you!