IF CONDITION

upaliwije — Sun, 13 Jul 2014 10:43:52 GMT

LOAD

NOTE,

BCOD,

YEAR,

MONTH,

('AC') AS GROUP_CODE,

Sum(if(GROUP_CODE= 'A', 1, if(GROUP_CODE= 'B', -1, 0)) * AMOUNT) as AMOUNT,

('AD') AS GROUP_CODE,

Sum(if(GROUP_CODE= 'A', 1, if(GROUP_CODE= 'D', -1, 0)) * AMOUNT) as AMOUNT

Resident TB

group by NOTE,BCOD, GROUP_CODE,YEAR, MONTH

My above script runs correctly without two lines highlighted in Red. When I add lines in red I get the following message when loading data

field names must be unique within table

Pls help me to rectify my script and I want the lines in red as well

Re: IF CONDITION

its_anandrjs — Sun, 13 Jul 2014 10:48:19 GMT

In the same table load the two fields name should not same try some thing different like load another table and concatenate this tables but the second table has fields

('AD') AS GROUP_CODE,

Sum(if(GROUP_CODE= 'A', 1, if(GROUP_CODE= 'D', -1, 0)) * AMOUNT) as AMOUNT

Ex:-

Table1:

LOAD

NOTE,

BCOD,

YEAR,

MONTH,

('AC') AS GROUP_CODE,

Sum(if(GROUP_CODE= 'A', 1, if(GROUP_CODE= 'B', -1, 0)) * AMOUNT) as AMOUNT,

Resident TB

group by NOTE,BCOD, GROUP_CODE,YEAR, MONTH

Concatenate(Table1)

Table2:

LOAD

NOTE,

BCOD,

YEAR,

MONTH,

('AD') AS GROUP_CODE,

Sum(if(GROUP_CODE= 'A', 1, if(GROUP_CODE= 'D', -1, 0)) * AMOUNT) as AMOUNT

Resident TB

group by NOTE,BCOD, GROUP_CODE,YEAR, MONTH

topic IF CONDITION in QlikView

IF CONDITION

Re: IF CONDITION