topic Re: [Script] Create new column in QlikView

[Script] Create new column

Fri, 17 Oct 2014 08:26:37 GMT

Hi guys,

There is lots of question about creating new column in the script, but unfortunately I couldn't find answer for my question.

I need to create 1/0 (True/False) column based on the other 3 columns value. So if I have in my existing columns at least one 0 it should have 0, if there is no 0 then it should be 1.

Any help?

Thank you,

Andrzej

Re: [Script] Create new column

maxgro — Fri, 17 Oct 2014 08:28:07 GMT

load

existingcolumn,

if(existingcolumn=0, 0, 1) as newcolumn

,,,,

from

....

// true false

load

existingcolumn,

if(existingcolumn=0, false(), true()) as newcolumn

Re: [Script] Create new column

Fri, 17 Oct 2014 08:39:54 GMT

I am sorry, I didn't explain well what I need. Here is an example:

a	5	a	0
a	0	b	1
a	12
b	12
b	9
b	10

so first 2 columns is what I have and 3-4 what I need

"a" and "b" are names of the partner so if this partner has atleast one 0 then in the new column it should be 0 othervise 1.

I don't mind if result will look like:

a	0
a	0
a	0
b	1
b	1
b	1

Re: [Script] Create new column

Fri, 17 Oct 2014 08:45:27 GMT

Hello

if((column1=0 or Column2=0 or column3=0), 0, 1)

Regards

Re: Re: [Script] Create new column

Fri, 17 Oct 2014 09:02:46 GMT

First find the minimum value of your second column with a group by and then use that value to determine the 0 or 1 for the new column

LOAD *,
          If(MinValue = 0, 0, 1) As NewColumn
LOAD partner, Min(Column2) As MinValue
GROUP BY partner
Resident MyTable

Re: [Script] Create new column

maxgro — Fri, 17 Oct 2014 09:14:11 GMT

load * inline [

f1,f2

a,5

a,0

a,12

b,12

b,9,

];

[0 or 1]:

load

f1,

min(if(f2>0,1,0)) as f3

Resident t

group by f1;

drop table t;

Re: [Script] Create new column

Fri, 17 Oct 2014 09:56:38 GMT

Hi Dick,

I can't make this code working can I sent you PM with script I have?

Re: [Script] Create new column

Fri, 17 Oct 2014 10:09:28 GMT

Adjusted script done what I needed:) thank you