This content has been marked as final. Show 2 replies
I have a requirement where I have to replace blanks in the existing field values which has blanks with Null
(). For this requirement I'm using if( len(trim(CORP))=0, null(), CORP).
The above requirement works with single field, but I have to do the same thing for all the fields available in the data set. Can anyone help me how to replace blanks for the entire dataset's available across all fields with Null().