4 Replies Latest reply: Sep 24, 2014 6:21 AM by sujeet Singh

Hi freiends,

I have a table like

A B C D                    E

1  2 3 sales              Profit

2 3 4  Commisions     Loss

6 8 9  Margin            Profit

Now I have to load based on coumns D and E using resedent load.

If D= sales and e= Profit then A-B as xxxx

else if D=Commission and E = Loss as YYY etc

Thanks

Pavan

• ###### Re: If condition in load

HI,

Try liek this

*,

If (D= 'Sales' and E= 'Profit', A - B,

If(D='Commissions' and E = 'Loss', somecalculation)) AS XXXX

Regards,

Jagan.

• ###### Re: If condition in load

Jagan has given you the way to do so ,

May this in detail will make you clear

Table2:

,If (D= 'Sales' and E= 'Profit', A - B,

If(D='Commissions' and E = 'Loss', somecalculation)) AS XXXX

resident Table1;

drop table Table1;

Now you can use one more resident load from table 2 if you want to exclude on basis of field XXXXX.

• ###### Re: If condition in load

Hi pavan,

In the script.

Tab1:

Tab2:

*,

If (D= 'Sales' and E= 'Profit', A - B, If(D='Commissions' and E = 'Loss', somecalculation)) AS New Field

resident Tab1;

Regards

KC

• ###### Re: If condition in load

Hi

Try like this