How to handle null or empty element
Hi,
I need to use null and empty condition in router. curretnly i am using:-
$ZSDATA.IDOC.EDL2.EDL4.BEL != “”
but i feel i am not handling it correctly.
Any inputs?
Forum Discussion
@dgupta The Excel Parser Snap respects the cell formats present in the input file. The Parser output will look similar to the sheet when opened in Excel, and the Snap performs no additional truncation.
It seems like the cell referenced is formatted with the Currency type. If you’d like to retain the type, the decimal width needs to be increased to accommodate the additional decimal places. The default decimal width for the Currency type is 2.
The alternative is to set the cell to use the Number type with decimal width set to Auto. This is probably what you’re looking for since the expected output lacks a $ sign.
