Masked Member Health ID

Cmacvp16

New Member
Joined
Aug 8, 2002
Messages
44
I want to use Power Query to take a member "Health ID" number and create a new column of "Masked ID" to hide their identity. Use 4 digits and increment by 1.

Health ID Masked ID
12345678911 0001
12345678911 0001
33333333333 0002
45454545454 0003
33333333333 0002
45454545454 0003
 

Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.
One way I solved this problem was to create a query on Health ID and group by the Health ID. This gave me a list of unique IDs. Using Power Query I added an index starting at 100 and incrementing by 1.

Next I merged the medical data query I originally pulled that had 1000 records to add in the Index column. I renamed the Index column "Masked ID".

Is there a way to add a column using Health ID and creating Masked ID directly in the original data file?
 
Upvote 0

Forum statistics

Threads
1,213,510
Messages
6,114,034
Members
448,543
Latest member
MartinLarkin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top