SOLVED
Dynamically column names
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Zaid
8 - Asteroid
‎04-11-2019
12:12 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
Solved! Go to Solution.
Labels:
- Labels:
- Preparation
1 REPLY 1
jamielaird
14 - Magnetar
‎04-11-2019
12:45 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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!
