topic Re: Is it possible for a Dynamic type output to allow null values in Talend Studio

Is it possible for a Dynamic type output to allow null values

aaronrums — Fri, 15 Nov 2024 21:12:17 GMT

I am using a Dynamic type output as the single schema field for a SQL Server tDBOutput column.

I have noticed that if a null value comes in from the query, that column is not added to the dynamic output, almost as if it is ignored.

Is it possible to avoid this? I know that I can default the values using ISNULL or COALESCE in SQL, but I would like to avoid this because we may want to know when the value from the source is actually null.

Thank you kindly!

Aaron

Re: Is it possible for a Dynamic type output to allow null values

Anonymous — Tue, 05 Dec 2023 06:41:43 GMT

@Aaron Rumley , I think we need to check what's the real value is read from the source using Dynamic schema if a null value comes from the source. To access the column properties and get the column value, please refer to this KB article.

Re: Is it possible for a Dynamic type output to allow null values

aaronrums — Tue, 05 Dec 2023 13:53:58 GMT

thanks, that's a helpful article to start with.