how to eliminate all null values when saving in CSV

[danny4202001]

Hello Friends,

How to write a script to save all fields in CSV except those that have zero values in the same row?

in the below case how to avoid Items 1,2 & 3 and all calculations are sum(if(statements

Thanks,

D

[Vegar]

You could try something like this.

ToStore:

NoConcatenate  Load *

From/Resident Source 

Where 

MTDShipped <>0

AND CMTMOpen <> 0

etc...

;

Store ToStore Into MyCsv.csv (txt);

Drop table ToStore;