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 · Accepted solution]

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. 

[bryan_ram2613]

@CharlieS Thank you soo much. I used the generate row tool and figured that out as well. Yours works better for the columns names. Thanks again.