tJoin problem with results

Two Stars

tJoin problem with results

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

Seven Stars

Re: tJoin problem with results

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

Nine Stars

Re: tJoin problem with results

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.
Two Stars

Re: tJoin problem with results

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

Do you know this problem?

Nine Stars

Re: tJoin problem with results

@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 -

tJoin-1.JPG

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

tJoin-2.JPG

Two Stars

Re: tJoin problem with results

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             -

Two Stars

Re: tJoin problem with results

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

Nine Stars

Re: tJoin problem with results

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

Re: tJoin problem with results

I remove this column as shown in this picture, but it doesn't work stillresult.JPG

Nine Stars

Re: tJoin problem with results

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.