Preserving format till specific row

VijayAnaparthi

I have a Excel sheet which contain 200 rows.

I have Alteryx tool which producing 100rows, now i am using output tool to store these 100rows by overwriting above sheet also i am preserving a format till 100th row only and i am able to replace till 100th row with preserving format but problem is that even though i want only 100rows in the Excel but still it is showing 200rows because orginal sheet has 200rows. So now is there anyway i can remove those rows i.e 101 to 200.

PanPP

Hi @VijayAnaparthi 

1) Instead of overwriting the sheet, maybe you can make a new sheet within the excel files?

2) You can also Overwrite File (remove) if that is an option?

3) You can also bring the excel sheet into Designer, and use a sample tool to only keep the first 100 rows and then output to the same sheet.

This will need to be run first, then run your original workflow.

Hope this helps. If it does, please like the post and mark it as a solution.