You are not logged in.
Can you say to me if there is a function which allows to cross all the values of a column of table
I really want to help you but here I can't.
What is your tMap configuration ?
What is the result expected ? What is missing ?
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
Can you show more detailed information? Please show some input data and what are you expected result.
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