Forum Discussion
Replace duplicates with null
Hi everyone, I have a table that I need to remove the duplicates in the "Source.Name.1" column but keep the first value when it changes. So source name would be row 1 "1K2321C0172" and nulls unt...
Hi PI2023
This link may help you. You need to have an index column. Then you could use an if statement to compare the value in the current row with the value in the next/previous row.