Transpose tool issue with selecting key Columns
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi,
I have prepared a workflow to clean data present in an excel file in different sheets. I am facing issue with transpose tool. I want to select 1st three columns as key columns in transpose tool (used in my workflow). However, I do not know why every time, I run this workflow or I used it for my 2nd sheet, chosen 3 columns in transpose tool gets de-selected and again, I have to choose it.
I want to know the reason why it is happening with my workflow. And, how can I fix 1st three columns as key fields in transpose tool, so whenever I run it for present sheets in the workflow (sheet1 or sheet2), my 3 columns do not get transposed.
Please help me with this!
Thanks!
Solved! Go to Solution.
- Labels:
- Workflow
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Unfortunately that will happen because you have a dynamic rename before the transpose. Alteryx does not maintain the metadata after the dynamic rename as it does not know what could be the field names unless it runs. One option would be having the transpose inside a macro, where you send the field names to be selected from outside the macro. I also have seen cases where if you insert the dynamic rename into a macro and enable the option Output field changes based on macro data input in the interface designer it might work.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you for your response.
Can you please give me one workflow as an example ? It will help me understand it better and I will be able to make changes in my workflow.
Regards,
Rahul
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
or, is there any other way for getting this outcome without using dynamic rename ? Because, I want to run this workflow for multiple sheets, so I will be adding control parameter ( one at input and second at output) then I will use it.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@Rahul_Analyst use a select tool after the dynamic rename tool then connect to the Transpose tool, this will solve your issue. I think even though the dynamic rename changes value but passing the original value to the next tool, thats why the Transpose tool was not able to recognize the fields and deselecting each time
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
It is not giving me the correct output. I have put select tool before the transpose. I have chosen 1st three columns as a key columns but in output of transpose taking no field as a key columns and transposing each column.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
As i can see it uncheck the 3 columns from dynamic rename this way it retains the name like below.
Output:
Let me know does this work for you.
Hope this helps : )
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi,
I am not sure if I know that is the expected output but what I would recommend is to keep the odd naming convention of the columns keep it F1 F2 F3 etc and correct it after the transpose tool.
Union tool at the end will allow you to correct the naming convention:
