Question Re: Assign a default value to column in flowgraph in Technology Q&A

Assign a default value to column in flowgraph

PallaviU — Thu, 15 Feb 2018 09:20:15 GMT

Hi,

I need to assign a default value to a column in the flowgraph.I used map operation transform to assign the value in the mapping tab as shown below.

when I try to execute the flowgraph it throws an error as shown below.

Could you please suggest to resolve the issue?

Thanks

Pallavi

Re: Assign a default value to column in flowgraph

jeff_k — Thu, 15 Feb 2018 15:30:37 GMT

Hi Pallavi,

I think you probably want to use the HANA IFNULL() function. The function returns the first non-null value in its list, so put the mapped column first, and have a default value follow it in the list. Your mapping should look something like this:

IFNULL("INPUT"."FILE_TYPE", "E")

You said there is some kind of error, but I don't see any error message in the post. Can you share the error text?

Thanks,
Jeff K

Re: Assign a default value to column in flowgraph

PallaviU — Fri, 16 Feb 2018 11:37:53 GMT

Hi Jeff,

Thanks for your quick response. I have tried with the option mentioned but encountered with the same error. May be the error is in any other part of flowgraph I am not sure. Please find the error snapshot and suggest to proceed further.

error.jpg

Thanks

Pallavi

Re: Assign a default value to column in flowgraph

jeff_k — Fri, 16 Feb 2018 15:15:30 GMT

The error comes from an ELSE somewhere in the design of the flowgraph. I don't see any ELSE in your first screenshot so it must be another mapping.

Re: Assign a default value to column in flowgraph

PallaviU — Wed, 28 Mar 2018 10:02:39 GMT

Hi Jeff,

I have removed the if condition and the error is resolved. However I have added the addtional column and assigned default value in the filter.

Thanks

Pallavi