i used expression evaluator to give or insert blank record values into Null Values ,how can i achieve this .
this is my incoming data from origin.
![](https://uploads-us-west-2.insided.com/streamsets-en/attachment/2bc9a6c7-f7d1-4f3d-880f-72732a31d51c.png)
these type field had Blank ,but i want to feed Null ..i used this expression:
${str:isNullOrEmpty(record:value('/TYPE_1099'))?NULL:record:value('/TYPE_1099')} but it fails .
![](https://uploads-us-west-2.insided.com/streamsets-en/attachment/0ca5affd-b519-43d1-8223-def37671c784.png)
Best answer by Bikram
View original