function Validate() {
    var salesRows = tblSalesDump.rows().nodes().toArray();
    var pd60Rows = tblPD60Dump.rows().nodes().toArray();

    function ValidateSAP(dataArray) {
        $(dataArray).each(function (index, field) {
            $(field).attr('data-salesdumpdata-id', tblSalesDump.row(index).column(19).data()[index]); //toberemove
            for (var i = 0; i < PRIMARY_COLUMNS.length; i++) {
                if ($(field).children('td').eq(i).html() == "" && !$(field).children('td').eq(i).hasClass('missingData') && i != 19 && i != 20 && i != 4 && i != 13) {

                    $(field).children('td').eq(i).html("MISSING DATA");
                    $(field).children('td').eq(i).addClass('missingData');
                    $(field).children('td').eq(i).attr('column-name', DATA_PRIMARY_COMLUNMS[i]);

                    $(field).children('td').eq(i).attr('data-salesdumpdata-id', tblSalesDump.row(index).column(19).data()[index]);
                    //$(field).children('td').eq(i).attr('column-name', );
                }

                else if (i == 0 && !$(field).children('td').eq(i).hasClass('missingData')) {
                    if (!artNumList.includes($(field).children('td').eq(i).html()) && !$(field).children('td').eq(i).hasClass('notFound')) {
                        var currentText = $(field).children('td').eq(i).html();
                        currentText = currentText + " (Unmaintained)";
                        $(field).children('td').eq(i).html(currentText);
                        $(field).children('td').eq(i).addClass('notFound');

                        $(field).children('td').eq(i).attr('column-name', DATA_PRIMARY_COMLUNMS[i]);

                        $(field).children('td').eq(i).attr('data-salesdumpdata-id', tblSalesDump.row(index).column(19).data()[index]);
                    }
                }

                else if ((i == 12) && !$(field).children('td').eq(i).hasClass('missingData') && $(field).children('td').eq(i).html() != '0020214381') {
                    if (!customerCodeList.includes($(field).children('td').eq(i).html()) && !$(field).children('td').eq(i).hasClass('notFound')) {
                        var currentText = $(field).children('td').eq(i).html();
                        currentText = currentText + " (Unmaintained)";
                        $(field).children('td').eq(i).html(currentText);
                        $(field).children('td').eq(i).addClass('notFound');
                        $(field).children('td').eq(i).attr('column-name', DATA_PRIMARY_COMLUNMS[i]);

                        $(field).children('td').eq(i).attr('data-salesdumpdata-id', tblSalesDump.row(index).column(19).data()[index]);
                    }
                }
                else if ((i == 10) && !$(field).children('td').eq(i).hasClass('missingData') && $(field).children('td').eq(12).html() == '0020214381') {
                    if (!customerCodeList.includes($(field).children('td').eq(i).html()) && !$(field).children('td').eq(i).hasClass('notFound')) {
                        var currentText = $(field).children('td').eq(i).html();
                        currentText = currentText + " (Unmaintained)";
                        $(field).children('td').eq(i).html(currentText);
                        $(field).children('td').eq(i).addClass('notFound');
                        $(field).children('td').eq(i).attr('column-name', DATA_PRIMARY_COMLUNMS[i]);

                        $(field).children('td').eq(i).attr('data-salesdumpdata-id', tblSalesDump.row(index).column(19).data()[index]);
                    }
                }
                else if (salesDumpDataDBList.includes(field)) {
                    $(field).addClass('alreadyExists');
                }
            }
        });
    }

    function ValidatePD60(dataArray) {
        $(dataArray).each(function (index, field) {
            for (var i = 0; i < PD60_COLUMNS.length; i++) {
                if ($(field).children('td').eq(i).html() == "" && !$(field).children('td').eq(i).hasClass('missingData')) {
                    $(field).children('td').eq(i).html("MISSING DATA");
                    $(field).children('td').eq(i).addClass('missingData');
                }

                else if (pd60DumpDataDBList.includes(field)) {
                    $(field).addClass('alreadyExists');
                }
            }
        });
    }

    function SplitAndValidate(arrayTBS, callback) {
        var maxLength = 400;
        var start = 0;
        var end = maxLength;
        var repetitions = Math.ceil(arrayTBS.length / maxLength);

        for (var i = 0; i < repetitions; i++) {
            var tempArray = arrayTBS.slice(start, end);

            loadingProgress = end / arrayTBS.length;

            callback(tempArray);

            start += maxLength;
            end += maxLength;
        }
    }

    SplitAndValidate(salesRows, ValidateSAP);
    SplitAndValidate(pd60Rows, ValidatePD60);
}