Cross Tab

Question

Hi All,

I am trying get my head around the rationale used by Alteryx to transpose tables. As a test, I want to remove empty columns in the final output (I know I can use data cleaning) so, I first transpose the table, add status and filter out anything that is not empty. Then I want to put it back the way it was, bar empty columns. In my mind it should be straightforward but Alteryx has a mind of its own.

What am I doing wrong?

Test Cross Tab.yxmd

ArtApa · Accepted Answer

Hi @sdemichelis -

1) You don't need to add a status. You can filter out Empty values.

2) You simply need to add a Record ID tool and then use RecordID as key in your Transpose and Cross Tab tools:

3) You can use not only Data Cleansing, but also a Multi-Field to achieve the same.