Hello All,
I have 28 excel files and from each file I only need 3-4 columns of data. How to do this?
Hello All,
I have 28 excel files and from each file I only need 3-4 columns of data. How to do this?
@ramshiva_reddy after reading the excel file you can use the āFilter Datatableā activity to only include specific columns and then use the āMerge Datatableā activity
Using a for each loop you can iterate over a list containing all paths of the 28 excel files. You can use this list as the input to read range inside the for each loop
Use for each file in folder activity to iterate the files from the folder.
Take an assign activity and store the each file path in a variable.
In Read range workbook activity or in Use excel file pass the file path variable.
If you want to keep the 4 columns and remove the other columns. Then use the filter datatable activity to keep the required fields.
Hope it helps!!
Create an excel file Fill the excel names and column ranges and sheet name in a sheet
Take For each loop
and then write the data to the excel
Hello,
If I require 1st,3rd and 7th columns from 1st excel file, 2nd, 5th and 6th columns from 2nd excel file and so on. there is no particular format of columns. How to do this?
Try this:
Hope it helps.
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.