I was using filter data table activity. After write the data back to excel, i found that there is some extra column name Column1, Column2, Column3 …, does anyone know what’s wrong in my work?
Can you sow what your filter activity looks like for filter and output columns?
Would you please share snap of filter activity?
Also, if you are using Write Range, check if Add Header check box is set to True under Options property for Write Range activity.
Also the Output columns
Have you used add headers? Which doesn’t contain any header value??
Nothing wrong with your code. In source Excel file, check if the Columns G,H,I,J have any values or white space.
Or else try deleting all the Remaining columns and run your code.
Nothing is add or remove in output columns
Do write range of outPB2 without filter and check if you are getting extra columns for this as well.
Please follow below tutorial https://youtu.be/tOWBIeegoXM