Batch Macro with Percentile Creating Duplicates

[servingmosthigh]

Greetings,

I am pulling data from data.medicare.gov at the facility level.  I want to create percentile ranks for each facility by measure.  With the help of a colleague, I created a batch macro that calculates the percentile rank for each facility by measure.  However, it is generating lots of duplicates and killing performance.  Attached is one of several of the files from data.medicare.gov that I want to save into an Alteryx db and process through the batch macro at the same time.

Thank you for any help,

Scott 

[MarqueeCrew · Accepted solution]

@servingmosthigh,

It looks like I'm missing some of your macro.  You might want to package the workflow (Options: Export Workflow) to get it all into one file.  I did like the use of the download tool for your data.  That was convenient.

I am however still missing why you can't use the TILE tool and group by Provider ID and Measure ID to create equal records into 100 tiles that don't split tile on score and sort by score.

The data from the download doesn't have enough quantity by those measures to create tiles, but that's the approach that I would start with.

Cheers,

Mark

[servingmosthigh]

Hi Mark,

I have not used the Tile functionality in Alteryx, so now might be a good time to look into it :)

Thanks for the tip on packaging the workbook and please find attached.  Thanks for the help!!!

[servingmosthigh]

---

Hey Mark,

I am trying out the TILE method that you mentioned.  I believe it works, but it does not seem as precise as using the Percentile macro.  Do you think this is due to rounding or do I have it configured incorrectly?

I've attached the packaged workbook using the TILE method.

Blessings,

Scott