Hi All,
I have a dataset like below - my goal is to change the field name "Col B" needs to be changed to "27-Sep" i.e., first row of data from another field.
How do I use dynamic rename for this? Can someone guide please?
Col A | Col B |
27-Sep | 123 |
27-Sep | 122 |
Solved! Go to Solution.
Hi @Mj9715
Here is how you can do it.
Workflow:
1. Using select tool to get 1st row.
2. Using transpose to get column name and value.
3. Using multi-row formula tool to set new name to Col B.
4. Using dynamic rename to rename the headers.
Hope this helps : )
Hi @Mj9715
In your data, do you have other records with dates under Col B? So something like the table shown below?
Col A | Col B |
27-Sep | 123 |
27-Sep | 122 |
30-Sep | 159 |
30-Sep | 160 |
If yes, what do you want to do with this extra rows? Also how do you want ColA to be renamed?
Thanks,
Angelos
@AngelosPachis - Col A consists of a single date., i.e.,only 27-Sep for eg.
Col A name can be retained as is. However, the data corresponding to the date contained in column A (i.e., daily file) needs to be Col-B's field name.
Thanks for your reply @Mj9715 .
Here's how you can use the dynamic rename tool to rename column B based on the values of col A.
Hope that helps,
Angelos