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

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics