How to handle rows with null causing duplicate data

[annabergendal]

Hi,

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?

Thanks!

[kristoferahlin]

Hi Anna,

There are actually no duplications in your table since every row is uniqe. That being said, you can exclude rows containing null by adding a where-clause to your load statement, like:
LOAD

column1,

column2,

column3

FROM abc Where not(IsNull(column1)) and not(IsNull(column2)) and not(IsNull(column3));

Regards,

Kristofer

[annabergendal]

Yes you are right that there are no duplications, so I can exclude null like you suggest, but in the real app there are quite many columns (20 or so), do I have to name them explicitly or is there a way to include them all in one statement?

[#4]

You will need to name them, as far as I know there is no way to include them in one statement...

[annabergendal]

Hi,

what if I have the following data and want to get:

column1    column2    column3  

123            AA            SS

121            B                V

122            BB            NN

How can I merge the datarows?