This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I need your urgent help for this anomaly. This is between the dynamic rename and transpose tool. After using the dynamic rename to change the 1st column name, I use transpose to use the 1st column as the key column, but transpose tool doesn't detect the new column as shown below.
Dynamic Rename column headers (outgoing data to Transpose)
Dynamic Rename result/outgoing column headers
Transpose tool, not showing column names from dynamic rename.
Input from Transpose, not detecting the column names from Dynamic Rename
Note that my workflow is pretty huge and has over 300 tools due to the large data transformations and formatting. So, how is the transpose tool not detecting the new column names. I've tried running the workflow for it to pick up the new column and it worked for the first time but then it just reverts back to this state.
I suggest that you change the sequence of tool slightly. Instead of using a dynamic rename then the Transpose tool (you will need to run 2 times as the 1st time the Transpose tool does not have the names of the column yet... which removes the dynamism of the workflow), you can try something like this:
1) Keep the generic column name F1, F2, F3 etc... when you read in the file with first row containing data
2) Remove the row you don't want
3) Do the transpose on the generic column names (e.g. F1, F2, FY3...)
4) Then do join to replace the value F1, F2 etc... w the correct column names.
This is what I usually do for workflows that need both Transpose and Dynamic Rename. Hope this helps.
Hello, I'm coming across the same issue with Dynamic Rename + Transpose tool not picking up new column names - is this a bug in the Transpose or is it intended to work this way? It only seems to pick up the new field names if I reconfigure the Transpose each time.
I wanted to see if you had any ideas for a workaround for my practice exercise. The way I've built the workflow, it's reliant upon the column names from the Dynamic rename to indicate whether the sales data is 'actuals' or 'budget'.