Forum Discussion

bdehning's avatar
bdehning
Post Prodigy
3 years ago
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...
Need Help
  • Nathaniel_C's avatar
    Nathaniel_C
    3 years ago

    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

Nathaniel_C's avatar
Nathaniel_C
Community Champion
3 years ago

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