Transpose Tool Resets after blank data flow?
- 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
So it seems unlike a select tool that remembers missing data, the transpose tool doesn't remember the selected key columns and data columns. I set up a workflow to run automatically on the gallery once a week. And well sometimes on of my branches in my workflow will be blank and this week happened to be the second time. The Alteryx errored because the nothing was selected in the transpose tool, when this happened last time I assumed I forgot to set it up but now it im sure I did set it up before. Is there any way to get the transpose tool to remember your selections even if the data flow is blank?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
What's the exact error message you get?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
The key columns selections is reset to have none checked. So it throws me the error that at least one field must be selected.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Ah, I see. Yes this is annoying. So I'm guessing this happens when any of the key fields aren't in your dataset?
You can accommodate the pivoted Data Columns by selecting Dynamic and Unknown Columns
Key columns are more difficult. One way is to have a text input with headers of all the key columns you expect and then to union this with the dataset before the Transpose Tool. See attached example.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@PhilipMannering That would work if the Key column was missing, but if the whole data flow is missing then the union will also come out blank no? Thus giving the same error.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@Aviator0807 Hmmm... not sure. What causes the whole data flow to be missing?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@PhilipMannering The first financial week of a month is calculated different than the rest so in my workflow I use a T/F to split the first week. So depending on the week either of my branches could be empty, and cause this error.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I think the unioning solution posted above should still work in that case. Perhaps add another filter tool to simulate not records getting passed downstream to see if it would work.
