Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Everybody.
I have tried one logic but i did't get exact value, My script is below
If the Type = X, multiply the sales * -1, insert the amount into Rebates LC and set sales to 0.....
here Type , Sales, Rebates all are different fields,
Thanks in Advance
Munna@
:
IF (Type='X', 0, Sales) AS Sales,
IF (Type='X', Sales * (-1), 0) AS [Rebates LC],
:
Best,
Peter
:
IF (Type='X', 0, Sales) AS Sales,
IF (Type='X', Sales * (-1), 0) AS [Rebates LC],
:
Best,
Peter
try this
if(Type='X',(Sales*(-1)),Rebates)
SELECT (or LOAD)
...
if(Type= 'X', Sales * -1, Sales) as [Rebates LC],
if(Type= 'X', 0, Sales) as Sales,
...
Load
your fields,
If(Type = 'X', sales*-1) as [Rebates LC],
if(Type = 'X', 0, sales) as sales;
From TableName;
HELP PLEASE
Why does the IF portion not work ??
ODBC
CONNECT32 TO QED208;
SQL SELECT dtcrash as crash_dtcrash,
crashnum as crash_crashnum,
month(dtcrash) as crash_month,
year(dtcrash) as crash_year,
loctype as crash_locationtype,
hrmfeventdesc2 as crash_desc,
weathcond1desc as crash_weather,
roadsurfdesc as crash_roadsrufacecond,
manrcolldesc as crash_mandesc,
rdwyjuncdesc as crash_rdyjunction,
intrdwy1name as crash_road1,
intrdwy2name as crash_road2,
nointstnum as crash_stnum,
nointstname as crash_street,
hrmfeventcode2 as crash_hrmfeventcode2
FROM uqed.xacreports where ((date(dtcrash) >= (40909)));
SELECT if(nointstnum >'',nointstname,road1) as crash_location;
Hi,
Try your if with load Statement instead of Select Statement.
Like
ODBC
CONNECT32 TO QED208;
Test1:
SQL SELECT dtcrash as crash_dtcrash,
crashnum as crash_crashnum,
month(dtcrash) as crash_month,
year(dtcrash) as crash_year,
loctype as crash_locationtype,
hrmfeventdesc2 as crash_desc,
weathcond1desc as crash_weather,
roadsurfdesc as crash_roadsrufacecond,
manrcolldesc as crash_mandesc,
rdwyjuncdesc as crash_rdyjunction,
intrdwy1name as crash_road1,
intrdwy2name as crash_road2,
nointstnum as crash_stnum,
nointstname as crash_street,
hrmfeventcode2 as crash_hrmfeventcode2
FROM uqed.xacreports where ((date(dtcrash) >= (40909)));
Test2:
Load *,if(nointstnum >'',nointstname,road1) as crash_location
Resident Test1;
Drop tables Test1;