Skip to main content
Question

I want to correct the datatypes of all of my input field values ?

  • September 14, 2023
  • 1 reply
  • 21 views

lakshmi_narayanan_t
Discovered Fame

I WANT TO WRITE ALL THE FIELD VALUES THAT CONTAINS Blank Values INTO NULL 
I used these expression for to write specific one field = field ${str:length(record:value('/VENDOR_NAME_ALT')) != 0 ? record:value('/VENDOR_NAME_ALT') : 'null'}



but i want to use all  fields  that contains blank values means feed with  NULL . 
any other processor can replace these scenario

1 reply

Bikram
Headliner
Forum|alt.badge.img+1
  • Headliner
  • 486 replies
  • September 15, 2023

@lakshmi_narayanan_t 

Kindly try the below code snippet and check if it helps and let me know if you are having any issues.

 

 

Thanks & Regards

Bikram_


Reply