Forum Discussion
Solved
Removing duplicate values from a single row
I have an email column which has data like
[email protected],[email protected],[email protected]
[email protected],[email protected]
I need to keep only 1 email in the row
Expected output
How to go about this in power query.
I tried to extract data and keep contents before .com but having trouble with syntax of Text.Combine to add .com back within the same column in the power query steps
Hello - you can get the expected result by extracting the text before the comma, like this:
Table.TransformColumns(#"Changed Type", {{"Column1", each Text.BeforeDelimiter(_, ","), type text}})Result
1 Reply
Hello - you can get the expected result by extracting the text before the comma, like this:
Table.TransformColumns(#"Changed Type", {{"Column1", each Text.BeforeDelimiter(_, ","), type text}})Result