Power query - Replacing text field with dummy index

[MichaelF1]

Hi everyone

I need to redact an address line so I can send a data set to an external business partner.

How can I add a new column to give some sort of dummy index?

This is what I need:

existing column	new colummn
1 some street address	1
flat 3a	2
unit f	3
1 some street address	1
2 some street address	4

Thank you

[DOLEARY85 · Accepted solution]

Hi,

You can do this faily easily using the group by and index buttons on the ribbons.

1.  selct group by on the transform ribbon, select your address column and have the operation preform 'All Rows'

2. Select index column from the Add Column ribbon.

3. Expand the column that you created using the Group By function

4. you should have something that looks like the below image, then just delete any unneeded columns.

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

[amitchandak]

@MichaelF1 , what is the logic behind a repeat of index  1

You have Index and Sub index option

Power Query- Index Column: https://youtu.be/NS4esnCDqVw

Power BI and Power Query- Sub Category Rank and Index: https://youtu.be/tMBviW4-s4A