Forum Discussion
Solved
Expand columns doesn't work after Merging queries
Hi all, First I wanted to thank everybody participating in that community, you're of a great help ! I have a problem when I'm trying to expand a column after merging 2 queries. The mergin...
This might be a long shot, but sometimes the issue is simpler than it looks.
Does any of the columns that you are trying to join have trailing spaces?
Try to trim the columns or transform them using Text.Start and check if this resolves the issue that you're having.
I'd need to see the data and join type to really diagnose. You can get this if you do an OUTER join, but it isn't null for everything. It may be for many things, including the first 1,000 records that PQ typically shows.
About the only thing I can suggest is fitler out the NULL records and see if anything is left just to diagnose, but beyond that, I'd have to see data to see what is going on.