topic Re: tJoin problem with results in Talend Studio

tJoin problem with results

Anonymous — Fri, 06 Jul 2018 12:43:55 GMT

Hi,

I've problem with tJoin component. I'd like to join two tables. In both I've column emp_id which is Key definition.

In first table I've emp_id, level, first_name, last_name, ... In second: emp_id , address, ...

Now in tJoin in Edit schema I define my result which is emp_id, first_name, last_name, address.

Why I always get: emp_id - level - first_name - address ? Should we have in result always emp_id - level - first_name - last_name- address? Can't we choose only some columns?

Best regards,

bebebe

Re: tJoin problem with results

Anonymous — Fri, 06 Jul 2018 13:11:08 GMT

try tmap for joins and you have to select desired columns on output target table.

Re: tJoin problem with results

iamabhishek — Fri, 06 Jul 2018 13:21:54 GMT

Yes, you can choose your output as per your requirement in tMap. Made changes in your tMap output table as per your desired columns. To provide more help please post your job sample layout - some sample data and desired output.

Re: tJoin problem with results

Anonymous — Fri, 06 Jul 2018 13:25:37 GMT

I know that with tMap it works good. But I'd like to do this with tJoin.

Do you know this problem?

Re: tJoin problem with results

iamabhishek — Fri, 06 Jul 2018 13:56:53 GMT

@bebebe - it works pretty well for tJoin too. Not sure how you have configured your tJoin but doing like this would have your main & lookup output both shown -

and also keep in check that you have selected from both tabbed inputs in your tJoin schema editor

Re: tJoin problem with results

Anonymous — Fri, 06 Jul 2018 14:02:11 GMT

My data looks like this

1- emp

emp_id level first_name last_name

123 1 John Smith

124 2 James Ping

2- address

emp_id address

123 Street X 1

The result which I get

emp_id first_name last_name address

123 1 John Street X 1

124 2 James -

And should be

emp_id first_name last_name address

123 John Smith Street X 1

124 James Ping -

Re: tJoin problem with results

Anonymous — Fri, 06 Jul 2018 14:04:12 GMT

I don't want to have "level" in my result.

Re: tJoin problem with results

iamabhishek — Fri, 06 Jul 2018 14:08:05 GMT

Then you should remove the "level" from your tJoin schema - as simple as that.

Re: tJoin problem with results

Anonymous — Fri, 06 Jul 2018 14:42:13 GMT

I remove this column as shown in this picture, but it doesn't work still

Re: tJoin problem with results

iamabhishek — Fri, 06 Jul 2018 15:46:39 GMT

Able to see how you have defined your schema for tJoin. But what about option "include lookup columns in output" which I had mentioned in earlier post. Looking at your result which you mentioned looks like clearly there is mapping issue - check it once it should fix.