Replace all null to 1 when merging value from 2 tables

[ellysoo]

Hi, 

I am seeking for advise on how can I replace the null value in power query to become 1 when I am merging from another table? I was trying below method when merging, but when null appear in table 1, merging does not find the row that has "null" in table 2.  Appreciate some advice. 

[Syndicate_Admin · Accepted solution]

Hey you should be able to replace a specified value for a column using the "Replace values" function:

Right click on the desired column -> click Replace values -> Replace null by 1

[Anonymous]

Before merging what you can do in both tables is to pick the columns which on which you are merging and replace its null values with any other dummy number such as 99999999999. And after merging you can replace the 99999999999 with nulls.


You can use "Replace values" Function in Power Query, and replace the nulls with 1.
In Power Query, select your column and navigate to the Transform tab on the Power Query Ribbon and locate the "Replace Values" option and replace your null values with 1.

Thank you.
If my answer helps you, please mark it as solution.