topic Re: Scripting Issue in QlikView

Scripting Issue

Wed, 22 Apr 2015 09:56:45 GMT

Hi All,

I have a table as shown below:

Now wherever I have both values as 1 and 2 in column B for a particular value of column A, then it should be stored as 3.

The below table should be created in script.

Can someone please help me in implementing the above scenario?

Gysbert_Wassenaar — Wed, 22 Apr 2015 09:59:19 GMT

LOAD

sum(B) as B

FROM ...sourcetable...

GROUP BY A;

PrashantSangle — Wed, 22 Apr 2015 10:02:08 GMT

Hi,

try something like below

t1:
LOAD * INLINE [
    A,B
    A1,1
    A2,1
    A2,2
    A3,2
];

load A,if(A='A2' and match(B,'1','2'),'3',B) as new_B
Resident t1;

Regards

sunny_talwar — Wed, 22 Apr 2015 10:08:33 GMT

PFA

Table:

LOAD A,

FROM

[https://community.qlik.com/thread/161172]

(html, codepage is 1252, embedded labels, table is @1);

Table1:

NoConcatenate

LOAD A,

Sum(B) as B

Resident Table

Group By A;

DROP Table Table;

Best,

Sunny

Wed, 22 Apr 2015 10:14:27 GMT

PFA