Forum Discussion
captainlaw
Microsoft Employee
Microsoft EmployeeMerge Issue | Replace NULL
Hello Power BI Community, I'm trying to merge two table in Power BI queries, and I used full-outer join. As you can from the result screenshot below, It didn't quite merge the two, so I tried to...
It wasn't an issue with Cap Letters nor JOIN nor Merge. When I simply Merge again with FULL JOIN, it finally worked. I am also able to create a DimState from the merged table with combination of IF and Table.Distinct()
Issue resolved. Thank you all.
kcantor
Community Champion
Community ChampionYou aren't getting a clean merge because your data is not an exact match. Some are in All Caps. Clean the data and transform to make them match, then Merge again. You can also replace the null before creating a new column. Replace null, for example, with 1 the use that in your column instead of null.