Skip to Content

Assign a default value to column in flowgraph

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

4bwct.png (9.7 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Mar 28 at 10:02 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 15 at 03:30 PM

    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

    Add comment
    10|10000 characters needed characters exceeded