Displaying Numbers In a Range

bryan_ram2613

Hi All,

I have been working with ranges and hit a snag. I have played with the generate rows tool to try this but it isn't working for my data set or I am just not using it right. Below is my dataset. The MS-DRG columns are the range that I split out.

DX	MDC	MS-DRG	MS-DRG1
A000	06	371	373
A001	06	371	373
A009	06	371	373

I would like to add another column or multiple columns to display the numbers that are missing. For example, below is what I want. I do have some that show a larger range. 

DX	MDC	MS-DRG	MS-DRG1	MSDRG2
A000	06	371	372	373

Any assistance is much appreciated!

Best,

Bryan

CharlieS

Hi @bryan_ram2613 

I've attached a workflow that shows how this can be achieved. It's probably a little over-complicated, but it's solid. Also it names the MS-DRG fields starting with 1 rather than empty, I hope that's ok. I can fixed that if it's an issue. 

20190619-DRGRange.yxmd