Remove blanks in upload script

[KirstenKa]

How can I remove blanks from a certain column/value from the upload file and enter this in the upload script 

[BrunPierre · Accepted solution]

Try like,

Load [Column A],
           [Column B]

FROM Source
Where Len(Trim([Column B])) > 0;

[Chintam]

Hi, You can try using IsNull(),

you can use to create like a a flag or you can restrict through where condition while loading.

If(IsNull(FIELDNAME),'BLANK',FIELDNAME) as Flag - this will help to showcase with in the data.

Load *, From Source Where NOT IsNull(FIELDNAME);  - this will restrict loading the NULL values

[KirstenKa]

Thanks, I can try if it works. But I need to understand how to integrate this in the load script