Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
Partner
Partner

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
Highlighted
Partner
Partner

Re: How to handle rows with null causing duplicate data

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

Highlighted
Partner
Partner

Re: How to handle rows with null causing duplicate data

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?

Highlighted
Not applicable

Re: How to handle rows with null causing duplicate data

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

Highlighted
Partner
Partner

Re: How to handle rows with null causing duplicate data

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?