how to do an inner join in tmysqloutput on map

[Anonymous]

I have this job design.

map1

I'ld like to do this join

I tried to do that but I can't. I tried to drag "id" to "users_id", I tried to do some expression in "users_id" but I didn't have any success..

What I supose to do?

[cterenzi]

What you're asking for doesn't make sense. Joins are for relating data from multiple sources for the purpose of creating a single output. With a single input, you don't need to do a join since all values are present in your input.

Rather, what is your desired output given the input described in your screenshot?

[TRF]

You can make join only for input flow (left side), not for output flow.

[Anonymous]

Ok. I'll explain better...

In database model, row4 (glpi_usersmail) is a table created because a user can have more than one email.. so a multivalued attribute..

in glpi_users don't have the email attribute. I need to associate the id from "user" in "usersmails"

Why? Because when I run the job, in glpi_usersmails don't have any reference in "user"

I'm new usind the Talend Studio by the way

[Anonymous]

But I need to get the "email" field on LDAP and the "id" in the same job.

Some sugestion?

[Anonymous]

I believe you can get the "email" field on LDAP and the "id" in the same job by concatenating 2 fields  in TJavarow 

[cterenzi]

Do you need to look up the id for each email?

[Anonymous · Accepted solution]

Well, I did it.

I had to make another job. In the first job I make a tFileOutputDelimited for get the email and the key (that key I used to link to glpi_users)

So in the job2 I used this file join with user table to do that I needed.

It's works!

Thank's for everybody's help