Forum Discussion

hamadani's avatar
hamadani
Frequent Visitor
4 years ago
Solved

Replace (Blank) when Merging Two Tables

Hi,   I have two tables as follows:   Table 1 Case Id           Case Name 1 A 2 B 3 C 4 D 5 E 6 F 7 G Table 2 Case Id                  Stage 1 Stag...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi,
    I would recommend doing a full outer join and using this in power query to fill the blanks with what you desire.

    Column = IF(ISBLANK([Column]),0,[Column)

     

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi,
I would recommend doing a full outer join and using this in power query to fill the blanks with what you desire.

Column = IF(ISBLANK([Column]),0,[Column)