tJoin problem with results

[Anonymous]

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

[Anonymous]

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

[iamabhishek]

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.

[Anonymous]

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

Do you know this problem?

[iamabhishek]

@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

[Anonymous]

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             -

[Anonymous]

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

[iamabhishek]

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

[Anonymous]

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

[iamabhishek]

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.