Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have spaces here I want to fill the word , nulls or fill with 0(zero)
try this:
Load *,
if(isnull([Liquid Sub]) or trim([Liquid Sub])='',0,[Liquid Sub]) as [Liquid Sub New]
From YourDataSource;
try this:
Load *,
if(isnull([Liquid Sub]) or trim([Liquid Sub])='',0,[Liquid Sub]) as [Liquid Sub New]
From YourDataSource;
When applicable, please mark the answer as Correct.