topic Re: Adding columns values while load in QlikView

Adding columns values while load

Thu, 06 Nov 2014 00:01:14 GMT

Hello,

I have a excel file that has 3 value fields (columns) A, B and C that I want to add to get another column D.

"LOAD A + B + C as D" doesn't work somehow. I can of course create the D column in the source file while adding A, B and C, but is there a way I can sum A, B and C while loading?

thanks,

Manoj

Re: Adding columns values while load

Anonymous — Thu, 06 Nov 2014 00:16:02 GMT

Hi,

Make sure your script like this.

table1:

Load *, (A+B+C) as D;

Load *

FROM

(ooxml, embedded labels, table is Sheet1);

this should do.

BR,

chinna

Re: Adding columns values while load

Thu, 06 Nov 2014 15:35:00 GMT

Hi Chinna,

I did try preceding load but it did not work either. Let me try again and check.

thanks,

Manoj

Re: Adding columns values while load

Thu, 06 Nov 2014 15:37:41 GMT

try it

rangesum(a,b,c) as d

Re: Adding columns values while load

Thu, 06 Nov 2014 15:45:26 GMT

Hi,

Use numsum(A+B+C) as D

or else try to use resident load.

table1:

Load *

FROM

(ooxml, embedded labels, table is Sheet1);

Table2:

Load *,

A+B+C as D,

Numsum(A+B+C) as D1

Resident table1;

Drop table1;

Re: Adding columns values while load

Thu, 06 Nov 2014 16:14:04 GMT

That works. Thanks.

Manoj

Re: Adding columns values while load

MarcoWedel — Thu, 06 Nov 2014 16:18:17 GMT

very good.

So the trick was to treat null and non-numeric values as 0, like the range functions do.

regards

Marco