If condition in load

[#1]

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

[jagan · Accepted solution]

HI,

Try liek this

LOAD

*,

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

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

Regards,

Jagan.

[jyothish8807]

Hi pavan,

In the script.

Tab1:

Load your normal data from your sheet.

Tab2:

LOAD

*,

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

resident Tab1;

Regards

KC

[PrashantSangle]

Hi

Try like this

LOAD

*,

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

     If(wildmatch(D,'Commissions') and if(E,'Loss'), calculation)) AS NewField

Resident TableName

Regards,

[sujeetsingh]

Jagan has given you the way to do so ,

May this in detail will make you clear

Table2:

load *

,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.