how can I get QV to handle null in data rows and not cause duplicate data rows?
I have this problem when loading data to a dimension from several sources.
Simple example attached, I want the result to be:
column1 column2 column3
123 2 5
124 7 1
How can I do this?