Transpose Tool Resets after blank data flow?

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?

Workflow

Settings

Tips and Tricks

Transformation

Accepted answers

All comments

philipmannering

What's the exact error message you get?

Aviator0807

@PhilipMannering

The key columns selections is reset to have none checked. So it throws me the error that at least one field must be selected.

philipmannering

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.

Remember key columns.yxmd

Aviator0807

@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.

philipmannering

@Aviator0807 Hmmm... not sure. What causes the whole data flow to be missing?

Aviator0807

@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.

philipmannering

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.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703