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 

Mortality-Readmission with Macro.yxmd

Percentile_Ranking_SD.yxmc

MarqueeCrew

@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