topic Re: How to handle rows with null causing duplicate data in QlikView

How to handle rows with null causing duplicate data

annabergendal — Thu, 15 Jan 2015 21:19:41 GMT

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!

Re: How to handle rows with null causing duplicate data

kristoferahlin — Thu, 15 Jan 2015 21:44:52 GMT

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

Re: How to handle rows with null causing duplicate data

annabergendal — Fri, 16 Jan 2015 08:50:30 GMT

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?

Re: How to handle rows with null causing duplicate data

Fri, 16 Jan 2015 09:08:47 GMT

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

Re: How to handle rows with null causing duplicate data

annabergendal — Mon, 19 Jan 2015 21:34:29 GMT

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?