23306_en-US

liliconcom

Delete Empty Columns<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />

This JSL script will delete empty data columns.

Re: Delete Empty Columns

Piggybacking off @fitri , this worked for me

// get col names
colnames = dt << Get Column Names;

// delete empty columns
For( j = 1, j <= N Items( colnames ), j++,
 If( Col N Missing( Column( colnames[j] ) ) / N Row() == 1,
  dt << delete columns( colnames[j] )
 )
);

Re: Delete Empty Columns

Thanks :beaming_face_with_smiling_eyes:

Re: Delete Empty Columns

Simple and effective. Thanks

Re: Delete Empty Columns

my version as below .

dt = Current Data Table();

For( i = N Col( dt ), i >= 1, i--,

       If( (Col N Missing( Column( i ) ) / N Row()) == 1,

              dt << delete columns( i )

       )

);