Excel filter using if else

Help Activities
, ,
1

I have an excel file and i want to put data on the basis of name to other excel.

Please let me know the flow
what should i do

image

2

1.First you need to read the excel file by using the
Read Range Activity suppose the out = dt

And pass in the for each row data table

2.In the loop all the process you can use the
Write Range Activity and in the path you can mention like this

Condition= curreentRow(“names”).Tostring+“.xlsx”

Then it will create the dynamic excel file with names

@office_use

3

Hi @office_use ,
what is expect output?

4

Hi @office_use

To copy data from one Excel file to another based on a specific criterion (e.g., name), try this-

  1. Use the “Excel Application Scope” activity to open the source Excel file.
    Use the “Read Range” activity to read the data from the source Excel sheet
    into a DataTable.
  2. Use DataTable activities to filter the data based on the name criterion. You
    can use the “Filter Data Table” activity or write custom logic to filter rows
    where the name matches your desired criteria.
  3. If needed, create a new DataTable to store the filtered data. You can use
    the “Build Data Table” activity to define the structure of the new table.
  4. Use the “Excel Application Scope” activity to open the destination Excel file.
    Use the “Write Range” activity to write the filtered data (either the entire
    DataTable or the rows that meet the criterion) to the destination Excel
    sheet.
  5. Save and close the destination Excel file using the “Save Workbook” and
    “Close Workbook” activities within the “Excel Application Scope.”

You can adjust the filtering logic, column names, and other details based on your specific Excel files and criteria.

Thanks!!

5

@office_use

If based on name if you need to give the position or rank…then use join activity

Cheers