on 02-15-2018 9:20 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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
Thanks
Pallavi
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.