Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-02-2022 12:22 PM
- Create a UDF where you pass all the fields as Input that you need to take into consideration for a unique row.
- Create a list by splitting based on ' ' or ','.
- sort the list and
- concat all the elements of the list to derive "new field".
- Calculate dense_rank based on the derived field .
- Remove "new field".
