Forum Discussion

Rajan244's avatar
Rajan244
Helper I
3 years ago

Make duplicate column values to unique based the another two columns

Sample data: No Container_No Events Lat Lon 1 HLXU111 Dub-Rot 53.33306 -6.24889 1 HLXU111 Rot-Kara 51.9225 4.47917 1 HLXU222 Rot-Kara 51.225 4.7917 2 HLXU111 Dub-Rot 52.84235105 -6.16893985 2 ...
Need Help
Show and Tell
Tips and Tricks
amitchandak's avatar
amitchandak
Super User
3 years ago

Rajan244 , A new column

 

= [No] + Rankx(Filter(Table, [No] = earlier([No]) ), [lat],asc, dense) /10

Rajan244's avatar
Rajan244
Helper I
3 years ago

Hi amitchandak Thank you for your quick reply. Actually I forgot to mention, need to make unique based on Container_no, and events. 

Also, if its possible can you please add littlebit explaination about query, so I could change by my dataset. Thanks again.

 

Thanks amitchandak 

Used:

 

!no = RANKX(His_data, COMBINEVALUES(",", His_data[Container_No],COMBINEVALUES("-",[From],[To])),, ASC, DENSE) + ([no]/10)