refer this example and build it.
Location and Age columns are empty and 0 values respectively.
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<link href="https://cdn.datatables.net/1.10.13/css/jquery.dataTables.min.css" rel="stylesheet" />
<script src="jquery.js"></script>
<script src="https://cdn.datatables.net/1.10.13/js/jquery.dataTables.min.js"></script>
<script>
var table;
$(document).ready(function () {
table = $('#example').DataTable({
"paging": false
});
var columnsCount = table.columns()[0].length;
var data = table.rows().data();
var columnIndexToHide = [];
for (var j = 0; j < columnsCount; j++) {
var icount = 0;
for (var i = 0; i < data.length; i++) {
var val = data[i][j];
if (val != '' && val != '0')
break;
else
{
icount++;
if (icount == data.length)
{ columnIndexToHide.push(j); break;}
}
}
}
for (var i = 0; i < columnIndexToHide.length; i++) {
table.column(columnIndexToHide[i]).visible(false)
}
});
</script>
</head>
<body>
<table id="example" class="display" cellspacing="0" width="100%">
<thead>
<tr>
<th>Name</th>
<th>Position</th>
<th>Location</th>
<th>Age</th>
<th>Start date</th>
<th>Salary</th>
</tr>
</thead>
<tbody>
<tr>
<td>Tiger Nixon</td>
<td>System Architect</td>
<td></td>
<td>0</td>
<td>2011/04/25</td>
<td>$320,800</td>
</tr>
<tr>
<td>Garrett Winters</td>
<td>Accountant</td>
<td></td>
<td>0</td>
<td>2011/07/25</td>
<td>$170,750</td>
</tr>
<tr>
<td>Ashton Cox</td>
<td>Junior Technical Author</td>
<td></td>
<td>0</td>
<td>2009/01/12</td>
<td>$86,000</td>
</tr>
<tr>
<td>Cedric Kelly</td>
<td>Senior Javascript Developer</td>
<td></td>
<td>0</td>
<td>2012/03/29</td>
<td>$433,060</td>
</tr>
</tbody>
</table>
</body>
</html>