Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

schema default values

Hi
Under what conditions can I use the schema default values?
Here's what I have done so far:
tRowGenerator: int and string variables
tmap: same fields out, but set the values to null.
In my tFileOutputDelimited I have set the default values to "10" and "default".
This doesn't pick up the defaults.
I have also tried to set the fields to nullable and non-nullable, I have tried to set the expressions in tMap to blank and have also set the values to 0 and "" but none of these pick up the defaults.
I know that I can use the ternary operator to test for null and set a default, but I just want to find out if the default schema values do work and when?
Thanks
Rick
Labels (2)
2 Replies
Anonymous
Not applicable
Author

hi,
you have to put default value into the input flow field "default".
trowgenerator don't generate a null value so do your test for example with tfixedflowInput.

but effectivly you cannot affect data with a default value into output row except with some filter or ternary method!
It sound a normal behavior ... change data with some default value when you write it, it's like prepare all your stuffs for "winter holidays" and drive to "miami beach" 0683p000009MACn.png (bad comparison's permited on Sunday !!!)
But one thing about those "null value" ... even (unfortunatly) if you have null value into your String field (!!!) with a rule "not nullable" you are able to write into some file without any alert or warning ....(see https://community.talend.com/t5/Archive/string-to-bigdecimal-conversion-error/td-p/175475 )
So manage your "possible" null value in all cases .
hope it enlighten you 0683p000009MACn.png
regards
laurent
Anonymous
Not applicable
Author

Thanks kzone,
Just to clafiry, the defaults are applied if a null is present in a non-nullable input, is that correct?
So does this apply to all input components?
Regards,
Rick