Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
HI,
Try liek this
LOAD
*,
If (D= 'Sales' and E= 'Profit', A - B,
If(D='Commissions' and E = 'Loss', somecalculation)) AS XXXX
Regards,
Jagan.
HI,
Try liek this
LOAD
*,
If (D= 'Sales' and E= 'Profit', A - B,
If(D='Commissions' and E = 'Loss', somecalculation)) AS XXXX
Regards,
Jagan.
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
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,
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.