Post a reply

Write your message and submit

Options

Click in the dark area of the image to send your post.

Go back

Topic review (newest first)

vital_parsley
2011-12-19 08:37:02

Thank you.

pedro
2011-12-19 08:21:11

Hi
You can creat issue about bug or expected feature at BugTracker.
Thank you for your feedback.

Best regards!
Pedro

vital_parsley
2011-12-19 08:17:54

Hi,

Thanks,But I still think that null is not an expected output in any case.

pedro
2011-12-19 06:07:15

Hi
Thanks very much for your interesting in Talend and your feedback.
We will think twice about this feature.
On one hand, it is convenient to save your settings.
On the other hand, it may confuse users.
We shall improve it.

Best regards!
Pedro

vital_parsley
2011-12-18 20:34:33

Hi,Thanx for ur reply.

This is what i have found.
You could consider the case as in my previous posts.

e.g

i have 2 tables Table A and Table B
Table A has
id  name
1 a
2 b
3 c
4 d
5 e

Table B has
id name_upd
1 t
2 u
3 v
4 w
5 x
6 y
7 z


Now when i join these 2 tables using tJOin with id as joiner
Case 1 :

Include lookup columns in output - unchecked
Inner join(with reject output) - checked

o/p :
1 a
2 b
3 c
4 d
5 e

Case 2 :

Include lookup columns in output - checked
o/p column :name
lookup clumn : name_upd
Inner join(with reject output) - checked

o/p :
1 t
2 u
3 v
4 w
5 x

Case 3 :

Include lookup columns in output - unchecked(w/o removing values in the grid )
o/p column :name
lookup clumn : name_upd
Inner join(with reject output) - checked

o/p :
1 null
2 null
3 null
4 null
5 null


Case 4 :

Include lookup columns in output - unchecked( removing values in the grid )
o/p column :name -------------This values are removed using the red X after checking the lookup columns in output checkbox and the  unchecking it.
lookup clumn : name_upd -------------This values are removed using the red X after checking the lookup columns in output checkbox and the  unchecking it.
Inner join(with reject output) - checked

o/p :
1 a
2 b
3 c
4 d
5 e

Is this the expected behaviour ??
I think that when i uncheck 'Include lookup columns in output' that time even the values are removed from the grid and i don't have to specifically remove them ,just unchecking should do the job.

Is it a bug ?

shong
2011-12-16 08:24:58

Hi
This option allows you to generate the lookup column in the output table, you need to configure the column mapping once this option is checked: the left side is the output column and the right side is the lookup column.

The column mapping is one by one in order, the first column of output table mappings the first column of main flow, if there are more columns in output table, the surplus columns will be null if they don't mapping the lookup columns.

By the way, tMap component performs the join (including the inner join and external join) more better, it provides an GUI window for your operation.  I suggest you to use tMap to design the job rather than tJoin.

Best regards
Shong

vital_parsley
2011-12-16 07:09:24

Thanx for ur reply.
I will make the changes int he code to get back the main flow values

But my question is by default the 'include lookup columns in output' is not checked so we get the main flow values
when i check it i get the lookup flow values in the target

But when i  unchecked it shouldn't the code be changed back to getting the main flow values ??

pedro
2011-12-16 03:38:01

Hi
When you check 'Include lookup columns in output', you can map lookup column with output column.
And the lookup values will be passed.
In Talend source code, it will change as follow.

Code:

if (util_tJoin_1.isJoined(row1)) {
      row3.name2 = util_tJoin_1.lookupValue.name  //pass value
}

Beste regards!
Pedro

vital_parsley
2011-12-15 20:21:35

Hi i was doing a test using tJoin component.
In which

i had 2 files both having id and names column in them.
i was joining these 2 tables using id i.e Input key attribute : ID and Lookup key attribute : row2.ID
now according to join the values from main flow should propagate;which was happening.
Now when i checked the property of : include lookup columns in output;that time the values from look up table were propagated to the target which is correct.
But when i removed this check and was then expecting the values from the main flow to be propagated to the target;i was receiving null!!

Why is this ?

Board footer

Powered by FluxBB