Forum Discussion
Solved
Server connected Table in Power Query
I have a table I connected to on a server to bring in one Column. I merge in another column to be used by that table. The connected table now has two columns but how can I easily edit row en...
Hi bdehning ,
If you cannot use replace for all your valued then you must have some kind of logic to only replace some of the values. How do you know which ones? Is it based on the first column? If so you can create a conditional column in Power Query - go to the Column tab - conditional column and build your new column. Use this third column that you build instead of the second column.
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel
I made a mistake in selecting the correct column originally. All is good,.