Use DeleteColumn variable in write range, it will work.
i tried but i dont know why columns are not getting deleted…
ok let me try here we have to use false in the qurey, so by this query we will get those columns which are requried… data will not be deleted from the column right?
Yes. I was mistaken before. False used to get the column we want to hold. True is used to remove duplicate rows.