Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
annabergendal
Partner - Creator
Partner - Creator

How to handle rows with null causing duplicate data

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!

4 Replies
kristoferahlin
Partner - Contributor III
Partner - Contributor III

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
Partner - Creator
Partner - Creator
Author

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?

Not applicable

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

annabergendal
Partner - Creator
Partner - Creator
Author

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?