SFMC Dynamic DataExtension Column Headings

sfmc-dynamic-dataextension-column-headings.js

<script runat="server">
 
        Platform.Load("Core","1");
        var hidden_fields = "_CustomObjectKey,Lookup_Flag";
        var DE = DataExtension.Init("DataExtensionName");
        var data = DE.Rows.Lookup(["Lookup_Flag"], [1], 10, "LookupField");
 
        if (data.length > 0) {
                Write("<table border='1' cellpadding='2' cellspacing='3' style='border-collapse:collapse;'>");
                Write("<tr>");
                for (var key in data[0]) {
                        if (hidden_fields.indexOf(key) == -1) {
                                        Write("<th>" + key.replace("_"," ") + "</th>");
                        }
                }
                Write("</tr>");
                for (var i=0;i<= data.length;i++) {
                        var d = data[i];
                        Write("<tr>");
                        for (var key in d) {
                                        if (hidden_fields.indexOf(key) == -1) {
                                                        Write("<td>" + d[key] + "</td>");
                                        }
                        }
                        Write("</tr>");
                }
                Write("</table>");
 
        }
</script>