topic Re: [resolved] tMap - default value in Talend Studio

[resolved] tMap - default value

Anonymous — Fri, 22 Apr 2016 10:08:33 GMT

Hallo,

I have following tMap.

In my output rows in case that the left outer join does not match I do not get the default I have assigned for the columns SeedValue and IncrementValue, instead I get null;

Re: [resolved] tMap - default value

Anonymous — Fri, 22 Apr 2016 10:47:12 GMT

Hi,
Did you get zero rows from your 'lookup' file? Is your match model "Unique Match" or "All match"? (sorry we don't understand this language)
Best regards
Sabrina

Re: [resolved] tMap - default value

Anonymous — Fri, 22 Apr 2016 13:11:35 GMT

Hi Sabrina,
I have one row from my lookup. My match model is Unique match.
Best regards, Walter

Re: [resolved] tMap - default value

Anonymous — Fri, 22 Apr 2016 17:05:41 GMT

"In my output rows in case that the left outer join does not match I do not get the default I have assigned for the columns SeedValue and IncrementValue, instead I get null;"
It sounds like your saying that you want to supply a default when the join fails; but your Job does not suggest that you're providing a default.
If you're getting null, then your join is not matching and you have no default being supplied.

Re: [resolved] tMap - default value

Anonymous — Fri, 22 Apr 2016 18:09:37 GMT

Sorry, but I do not understand your answer. As you can see in the picture of my tMap, I have assigned a default value!

Re: [resolved] tMap - default value

Anonymous — Fri, 22 Apr 2016 18:23:35 GMT

wtaus wrote:
Sorry, but I do not understand your answer. As you can see in the picture of my tMap, I have assigned a default value!

I can see a field named DefaultValue on your output schema, which is populated by your driving table. If it is null, then it is because this input data is null.
For the values that come from your look-up table, nothing happens if no look-up match is made, so the corresponding output fields may be null.
If by default, you mean to assign a value when a look-up fails, then I cannot see that from your tMap.

Re: [resolved] tMap - default value

Anonymous — Sat, 23 Apr 2016 08:57:46 GMT

If you look at the screenshot and the output scheme named withidentityinfo, you can see in the bottom right corner, that I have assigned a default for the variables SeedValue and IncrmentValue. However, when my lookup does not provide a match, I do not see these default values in my output row. If the default value for the case that the lookup fails needs to be defined at a different place, then I would be curious to know where I have to define the default instead.

Re: [resolved] tMap - default value

Anonymous — Sat, 23 Apr 2016 09:53:10 GMT

Got you.
They way I would achieve what you're after is to amend the output mapping: -
row9.SeedValue == null ? 0 : row9.SeedValue
...and you can externalise the default if you wish...
row9.SeedValue == null ? context.defaultSeedValue : row9.SeedValue

"DefaultValue" may or may not work in the way you're after; but I have always found it a troublesome feature and do not use it.

Re: [resolved] tMap - default value

Anonymous — Sat, 23 Apr 2016 15:47:31 GMT

modified the output mapping according to your proposal and it works.
Thanks