You are not logged in.
Let me explain my problem:
I use Tmap to make big changes in order to load them into tables. At the entrance of Tmap, I have a big table and MySQL queries based on other tables. For example, a query me back a "ZONE", a "Libelle", a "Typ".
My concern is the level of defining (bulding)expressions Tmap, I do tests on fields queries: "Libelle" for example .... but in the calculation, I noticed that TOS does not test all field values "Libelle"
Help me please
Can you show more detailed information? Please show some input data and what are you expected result.
This is my expression :
(!(row1.PLANNED_DELIVERY== null)&& (row1.PLANNED_DELIVERY.equals(row2.Libelle)))? row2.Typ:(!(row1.PLANNED_DELIVERY==null)&& (row1.PLANNED_DELIVERY.equals(row3.Libelle)))? row3.Typ :row4.Typ
For Input, i have differents data (row1 and row2ad row3...)
My problem : i remark that TOS does not test all field values "Libelle" in expression
how can i do to have a test on different values of Libelle (CONFORME, BUG, ....)
Cf : Image for the contains of row2