topic Re: Help with IF statement and adding additional columns in script in QlikView

Help with IF statement and adding additional columns in script

Sunil_Kenth — Tue, 18 Oct 2011 11:59:35 GMT

Hi,

I would like some help with IF syntax.

I am trying to add an additonal column called 'T2' in my table through the load script, this is what i have so far:

(

Tier2_Org_Area = 'Europe & Digital' OR

Tier2_Org_Area = 'USA', 'RED') as T2,

(

Tier2_Org_Area = 'Africa', 'Blue')

as T2

However when i reload the data i get an error message saying column names cannot be the same, I was hoping the second IF statement would just be concatenated to the first T2 column?

Any ideas?

Thanks

Sunil

Re: Help with IF statement and adding additional columns in script

its_anandrjs — Tue, 18 Oct 2011 12:03:31 GMT

Hi,

You have to write some thing like

IF(

Tier2_Org_Area = 'Europe & Digital' OR

Tier2_Org_Area = 'USA', 'RED',

IF(

Tier2_Org_Area = 'Africa', 'Blue') )

as T2

Rgds

Anand

Re: Help with IF statement and adding additional columns in script

Sokkorn — Tue, 18 Oct 2011 12:06:58 GMT

Hi Sunil,

I'm not sure with this help you or not

IF(Tier2_Org_Area = 'Europe & Digital' OR Tier2_Org_Area = 'USA', 'RED',
    IF(Tier2_Org_Area = 'Africa', 'Blue','Other')) as T2,

Let me know.

Regards,

Sokkorn

Re: Help with IF statement and adding additional columns in script

its_anandrjs — Thu, 20 Oct 2011 06:59:24 GMT

Hi,

You have to write some thing like see in example

Data:

Load * inline

[

Tier2_Org_Area

Europe & Digital

USA

Africa

];

Load

IF(

Tier2_Org_Area = 'Europe & Digital' OR

Tier2_Org_Area = 'USA', 'RED',

IF(

Tier2_Org_Area = 'Africa', 'Blue'))

as T2

Resident Data;

See the example file

Rgds

Anand