Conditional Split Expression
Hi Guys,
My input columns are
TotalSales Trans_Type
-0.10000000000000001 S
0.10000000000000001 S
-0.10000000000000001 V
-0.20000000000000001 S
I need to separate all the negative rows, according to trans_type. I am using below expression none of them are working.
Expression used:
Trans_Type = S
DataType = String
TotalAmount = Negative field
SUBSTRING(TotalSales,1,FINDSTRING(TotalSales,"-",1)) > 0 && Trans_Type == "S"
SUBSTRING(TotalSales,1,FINDSTRING(TotalSales,"-",1)) == "-" && Trans_Type == "S"
Output Required whenever Trans_Type is
S and negative in amount I need to slit those row.
TotalSales Trans_Type
-0.10000000000000001 S
-0.20000000000000001 S
Thanks in Advance,
D
October 31st, 2010 8:33pm
Why not to do this similar to what is described in this article:
http://www.bimonkey.com/2009/06/the-conditional-split-transformation/
Your condition would be something like TotalSales < 0 && Trans_Type == "S"
Arthur My Blog
Free Windows Admin Tool Kit Click here and download it now
October 31st, 2010 9:41pm