How to create multiple excel file based on condition from another excel

excel

#1

I have the requirement to read the excel and need to check for each distinct col1(column1) value, col2 in the manner that
if numbers of digits in col2 > 2 the we in to send them in 1 excel and if more than 2 then another excel.

So, per each col1 there would be two excel, one which is having data in col2 digit 2 and another more than 2.

Below is the example source table:


#2

Hi @kirti9000,

You can create multiple datatable based on your criteria and add data rows in the respective datatable if criteria is matching.

At last push that data table in Multiple Excel files or multiple Sheets in a single excel file, as per the business/process need.

Regards,
V