Talend community forum / Post a reply

Open Data SolutionsData Management solutionswarehouseOpen StudioBusinessExtract Transform LoadETL

You are not logged in.

Announcement

[2013-05-06] Boston Area User Group Meetup
[2013-05-02] NOTICE TO ALL TALENDFORGE USERS: maintenance completed
[2013-04-26] Talend Open Studio's 5.3.0 release is available
[2013-04-12] Ready for testing - Talend Open Studio's 5.3.0RC2 release is available
[2013-04-11] Talend’s corporate pages and groups on social media

Unanswered posts

Control execution of tLogrow based on context variable by x_ttl
Call [...] by vindalooman
Job generation from Talend Administration Console [...] by saukema
Talend doesn't interpret the excel subtotal function correctly by IPL_TSBSupport
tSAPInput component with RSAQ_REMOTE_QUERY_CALL by smartmart
LDAP timeout? by fvalentim
Problem with SELECT a.name AS a_name, b.name AS b_name input by kacper

Index
» Usage, Operation
» Tmap and Test on the values of attribute of tables in entrances

Post a reply

Write your message and submit

Name

E-mail

Message

Options

Never show smilies as icons for this post

Click in the dark area of the image to send your post.

Go back

Topic review (newest first)

Rgent: 2008-05-16 09:41:46

hello,

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

Thanks

mhirt: 2008-05-15 22:13:08

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,

Rgent: 2008-05-15 10:08:53

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

shong: 2008-05-15 09:22:42

Hello

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

Best regards

shong

Rgent: 2008-05-14 18:02:17

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

Announcement

Unanswered posts

Post a reply

Topic review (newest first)

Code:

Board footer