Workflow improvement

[RVDL]

Hi All,

See my simple workflow attached. I don't like the repetitive joins that I am using.

Hopefully it is clear from the workflow that for each ID I want to determine TYPE1_RANK, TYPE2_RANK and TYPE3_RANK.

This is just an example. In reality there are also TYPE4, TYPE5, ... up to TYPE10.

For each type I now have a join function to determine TYPE#_RANK. I don't like this approach though. Can this be done more efficient / simplified?

Thanks.

[ChrisTX]

Try a batch macro.  Under Learn > Academy, check out the Interactive Lessons.  Interactive Lessons - Alteryx Community

And under Academy, Videos: search for "batch".  The Video Training Index doesn't include all videos, so use the Search bar to search only Videos. 

  Video Training Index - Alteryx Community

  Build Your First Batch Macro! - Alteryx Community

  Batches Be Solvin’ - Alteryx Community

Chris

[Christina_H · Accepted solution]

Depending on what you want to do next, it's much easier to get the ranks by transposing the data first.  But if you need it in the same horizontal format you then need to crosstab everything back.

First browse tool is all the ranks vertically, second is back to horizontal.