topic Re: [resolved] tMap Expression Builder - multiple else if in Talend Studio

[resolved] tMap Expression Builder - multiple else if

Anonymous — Tue, 24 Jul 2012 21:23:49 GMT

Hi all,
I have a simple project with a tFileInputDelimited, tMap, and tMysqlOutput components. I'm trying to build a calculated field in the tMap component Expression builder, but all my attempts have failed to compile at this point. What I'm doing is fairly straight forward, in php it would look something like this:

if ($custPrice>0) {
                        // sale
                        if ($promoCode=='GP') {
                                $revenueType='G';
                        } else {
                                $revenueType='S';
                        }
                } else if ($custPrice<0) {
                        // return/refund
                        $revenueType='R';
                } else {
                        // no charge
                        if ($promoCode=='GR') {
                                $revenueType='D';
                        } else if ($productTypeIdentifier=='7' || $productTypeIdentifier=='7T' || $productTypeIdentifier=='7F') {
                                // upgrade
                                $revenueType='U';
                        } else if ($productTypeIdentifier=='1' || $productTypeIdentifier=='1T' || $productTypeIdentifier=='1F') {
                                // comp
                                $revenueType='C';
                        } else  {
                                // other! not expected
                                $revenueType='O';
                        }
                }

Basically the revenueType G, S, R, U or C is what I want to return to the output column. I seem to be able to do individual row1.column.equals lines properly - Is it possible to do in one expression in Talend? Or a better way to handle this?
Thanks!

Re: [resolved] tMap Expression Builder - multiple else if

Anonymous — Wed, 25 Jul 2012 02:52:08 GMT

Hi
The convenientest way is to create a custom routine(a java method) in Talend Studio.
Regards,
Pedro

Re: [resolved] tMap Expression Builder - multiple else if

alevy — Wed, 25 Jul 2012 03:29:53 GMT

Simply

row1.custPrice>0
?row1.promoCode.equals("GP")
 ?"G"
 :"S"
:row1.custPrice<0
 ?"R"
 :row1.promoCode.equals("GR")
  ?"D"
  :row1.productTypeIdentifier.matches("7|7T|7F")
   ?"U"
   :row1.productTypeIdentifier.matches("1|1T|1F")
    ?"C"
    :"O"

The whitespace is irrelevant but included for ease of reading. I've used a regex .matches comparison rather than multiple .equals comparison for simplicity.

Re: [resolved] tMap Expression Builder - multiple else if

Anonymous — Wed, 25 Jul 2012 21:20:34 GMT

alevy - thanks so much - that did the trick!