Four Stars

how to do an inner join in tmysqloutput on map

I have this job design.

map1map1

I'ld like to do this join

insideMap.png

 

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?

 

  • Data Integration
1 ACCEPTED SOLUTION

Accepted Solutions
Four Stars

Re: how to do an inner join in tmysqloutput on map

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)

job1.JPG

 

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

job2.JPG

 

It's works!

Thank's for everybody's help

7 REPLIES
Nine Stars

Re: how to do an inner join in tmysqloutput on map

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?
Seven Stars TRF
Seven Stars

Re: how to do an inner join in tmysqloutput on map

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

TRF
Four Stars

Re: how to do an inner join in tmysqloutput on map

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

Four Stars

Re: how to do an inner join in tmysqloutput on map

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

 

Some sugestion?

Four Stars

Re: how to do an inner join in tmysqloutput on map

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

Nine Stars

Re: how to do an inner join in tmysqloutput on map

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

Re: how to do an inner join in tmysqloutput on map

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)

job1.JPG

 

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

job2.JPG

 

It's works!

Thank's for everybody's help