added deleted column validation and fixed bugs