How to remove multiple columns at a time

Help Automation Ops
,
21

@anjani_priya

Have you tried this it writes in same sheet

22

I have used filter datatable but last 5 columns are creating duplicates
like I have 172 columns after deleted it should be 167 after I used filter datatable the last 5 columns are creating duplicate columns again and final columns are 172

23

@anjani_priya

Can you show your configuration please…it wpuld never create that way

Cheers

24

Capture200
Capture200562×650 18.7 KB

25

@anjani_priya

In the datatable the columns are deleted…but as you are writing to same excel the old data is retained…

Please either delete the sheet or excel and recreate after filtering…or you can write to a new excel and check…it would have only 167 columns

That way old data will be completely removed

Cheers

26

Is there another query to remove the columns in same sheet

27

@anjani_priya

You can use delete columns activity in excel to delete the last extra columsn

Or as said…delete the sheet and then write the data the sheet will be recreated fresh…

Cheers

28

how to put this process?

29

@anjani_priya

Try this, its working absolutely fine for same sheet :slight_smile:

Test.zip (2.5 KB)

Happy Automation :slight_smile:
Cheers!!

30

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.