Replace one column with index number

[Anonymous]

Hi,

In my report, I need to keep the Id to calculate distinct Id count. But I cannot use the real Id number. How to replace the real Ids with index number like 1, 2,3.......

The target is that customer cannot find the real Id in the report. In the Id column, the Id is not unique and long list of Ids.

Thanks

[Greg_Deckler · Accepted solution]

I would pull just your ID's in and make them unique (in another query). Add an Index column. Now Merge your queries. Remove your ID column and leave the Index column.

[Anonymous]

I did do that way but forgot the last step of "appending". Thanks