Pages: 1

Post reply

  • Index
  •  » Talend Open Studio for Data Integration » Usage, Operation
  •  » Tmap and Test on the values of attribute of tables in entrances

#1 2008-05-14 18:02:17

Rgent
Member
Registered: 2008-05-14
Posts: 14

Tmap and Test on the values of attribute of tables in entrances

Tags: [database, development, java, mysql, tos2.3.2]

Hello everyboby,

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

Thanks

Offline

#2 2008-05-15 09:22:42

shong
Talend team
Registered: 2007-08-29
Posts: 10289
Website

Re: Tmap and Test on the values of attribute of tables in entrances

Hello

Can you show more detailed information? Please show some input data and what are you expected result.

Best regards

         shong

Email:shong@talend.com
Choose Talend, Enjoy Talend!
New & Event: Talend Help Center
Talend-->the leader of open source data management and application integration solutions!

Offline

#3 2008-05-15 10:08:53

Rgent
Member
Registered: 2008-05-14
Posts: 14

Re: Tmap and Test on the values of attribute of tables in entrances

Hello,

This is my expression : 

Code:

(!(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


Uploaded Images

Offline

#4 2008-05-15 22:13:08

mhirt
Talend team
Registered: 2006-09-19
Posts: 1633

Re: Tmap and Test on the values of attribute of tables in entrances

RGent,

I really want to help you but here I can't.
What is your tMap configuration ?
What is the result expected ? What is missing ?

Regards,

Offline

#5 2008-05-16 09:41:46

Rgent
Member
Registered: 2008-05-14
Posts: 14

Re: Tmap and Test on the values of attribute of tables in entrances

hello,

Can you say to me if there is a function which allows to cross all the values of a column of table

Thanks

Offline

Post reply

Pages: 1

  • Index
  •  » Talend Open Studio for Data Integration » Usage, Operation
  •  » Tmap and Test on the values of attribute of tables in entrances

Board footer

Powered by FluxBB