Talend community forum / [resolved] Joining Two Tables

murthy516 · 2012-05-07 06:53:13

Hi All,

I'm new to talend.Here,I have two tables.Table1 consists of

Id Name
1 Jones
2 Ronaldo

table 2 consists of

Id City

1 Newyork
2 Losangels
3 Washington

My final table output must be

Id name city
1 Jones Newyork
2 Ronaldo Losangles
3 Washington

How can I configure in tMap component to get this final table output..I'm getting inconsistent result when I'm automapping these values in tMap..Can anyone suggest me please

Thanks
Krrish

pedro · 2012-05-08 12:01:38

Hi All

This topic is related to [Forum, topic 23665] Joining Two Tables.

Regards,
Pedro

Zehm26 · 2012-06-15 13:20:43

Hi All,

I am new to Talend.I started using it two weeks back.
While using the context load component,in the properties there is an option called print operations. Can any one tell me , what it is for?
I tried googling,But I didn't get a proper answer.

Many Thanks,
Zehm

shong · 2012-06-15 15:00:45

Hi Zehm

The option 'print operator' means to print the operator message on the console. eg:
tContextLoad_1 set key "id" with value "2"

Best regards
Shong

Zehm26 · 2012-06-18 05:54:47

Thank You Shong!

shong · 2012-07-09 09:04:52

Zehm26 wrote:
Hi Team,

I want to extract only the Date portion from the timestamp. can anyone please help me?
I want to do this conversion in tmap component. please help out

Hi Zehm26

What's date type of input data? Can you give us an example to explain your request?

Best regards
Shong

shong · 2012-07-09 14:18:55

Hi
You can convert it on tMap, see my screenshot.

Code:

TalendDate.parseDate("yyyy-MM-dd", TalendDate.formatDate("yyyy-MM-dd",row1.newColumn))

Best regards
Shong

Uploaded Images

Zehm26 · 2012-07-12 09:03:44

Thanks tons Shong.That worked out.

Best Regards,
Zehm

Zehm26 · 2012-07-12 09:28:10

Hi Dave,

Can i know about the Talend training you where mentioned in the below post. Is that an online training? please help.
Below iam pasting out one of your post regarding Talend training.

Pavan -

Right now, our certification exam is only available to people who have completed a training class with Talend. Very soon we will be making the exam available to anyone who wants to take the test, for a small fee. When we have all the mechanisms in place, we'll make an announcement with information about how to purchase. We should be ready in August, so expect an announcement then. We will also be rolling out additional certification tests for our other products over the following months, so watch for announcements about those new certification exams as well.

Thanks
Dave Cottle
Talend Training Director

Regards,
Zehm

Zehm26 · 2012-07-20 07:00:29

Hi Team,

I want to extract only year part from the date.

Here my date is of string datatype.

Example: date value is 2011-02. It is of string type

I want only 2011 to extract from this string. Can anyone please help me out.

Regards,Zehmal

shong · 2012-07-21 03:50:33

Zehm26 wrote:
Hi Team,

I want to extract only year part from the date.

Here my date is of string datatype.

Example: date value is 2011-02. It is of string type

I want only 2011 to extract from this string. Can anyone please help me out.

Regards,Zehmal

For better management, please report a new topic in DI section and then I will answer you.

Best regards
Shong

Announcement

Unanswered posts

#1 2012-05-07 06:53:13

[resolved] Joining Two Tables

#2 2012-05-08 12:01:38

Re: [resolved] Joining Two Tables

#3 2012-06-15 13:20:43

Re: [resolved] Joining Two Tables

#4 2012-06-15 15:00:45

Re: [resolved] Joining Two Tables

#5 2012-06-18 05:54:47

Re: [resolved] Joining Two Tables

#6 2012-07-09 09:04:52

Re: [resolved] Joining Two Tables

Zehm26 wrote:

#7 2012-07-09 14:18:55

Re: [resolved] Joining Two Tables

Code:

#8 2012-07-12 09:03:44

Re: [resolved] Joining Two Tables

#9 2012-07-12 09:28:10

Re: [resolved] Joining Two Tables

#10 2012-07-20 07:00:29

Re: [resolved] Joining Two Tables

#11 2012-07-21 03:50:33

Re: [resolved] Joining Two Tables

Zehm26 wrote:

Board footer