Excel data but not all to new sheet

Hello,

I have a excelfile with a dumb from our database. Each line has a status. I got 13 different statuses and got 300 lines with a status. I would like to make per status a new sheet and copy the lines with matching status to that sheet. Not all the data that is filled in needs to be copy only some cells need to come with. only row a,c,d,e,f,g,h,k needs to be copies to the new sheet.

any ideas?
it’s been a while since i’ve done this :slight_smile:

1 Like

Hey @justseldo, Welcome to the community.

  1. Read the complete excel range into a datatable
  2. Delete the unwanted columns
  3. Filter as per status by means of filter activity or linq query
  4. Write the filtered data into a new sheet
  5. Repeat 3 & 4

Hope this helps

Thanks :slight_smile:

Hi @justseldo,

I suggest to use the Filter Data Table Activity. In the output you can specify the columns to keep/remove.

1 Like

share one dummy excel input and required output also with dummy excel

i’m not able to upload a file.

yes this is what i knew.
But i can’t seem to put it in practice

1 Like

Will share the sample workflow asap.

Cheers :slight_smile:

thanks :slight_smile: