I am in the process where I have to extract the data from the website (there are 5 columns in the beginning), on which i perform the data manipulation.
I need to add 4 more columns into it while data manipulations at the end of it.
When I am extracting the data using data scraping, (and write in excel) I am getting 3 empty columns(without any headers also) in between and when I am adding 4 columns as expected, I am getting total 12 columns instead of 9 columns.
Columns Selection Mode - Specifies whether to filter the columns by keeping or removing them. This can be done by selecting the Keep or the Remove radio buttons. Selecting Keep only keeps the columns that are specified below, while selecting Remove deletes the rows that are specified below from the input DataTable . —> Use Keep
Column - The columns you want to keep or remove from the datatable → Mention your column names whichever required