I have a CSV File that has some columns who’s values are blank, I want to leave blank not null. how do I do this. If this was SQL I’d use a case statement: CASE WHEN condreaid IS NULL THEN ‘’ ELSE condreaid END AS ‘condreaid’ OR ISNULL(condreaid,’’) AS ‘condreaid’ The default tool is leaving …

Hi Ronald and welcome to the Community! You can use the “Modify column” action with the following expression: if( isempty([condreaid]), '', [condreaid]) or even simpler ifempty([condreaid], '') If all values in [condreaid] are supposed to be text, then you can use the “Convert data types” actio…

EasyMorph Community - Data preparation professionals and enthusiasts

IF NULL leave blank

dgudkov April 2, 2024, 10:43pm 5

Hi Rykie,

check out this topic: Replace in multiple columns

1 Like

To learn more about EasyMorph visit easymorph.com.