We have extended our Early Bird Tickets for Inspire 2023! Discounted pricing goes until February 24th. Save your spot!

Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer and Intelligence Suite.
SOLVED

Remove - All Records

suby
11 - Bolide

Hi All,

 

 Step 1 - I have copied this TEST - INPUT workbook  from my shared network drive to my local Desktop.

 Step 2 - In my workflow I'm taking TEST - INPUT workbook from my desktop folder.

 Step 3  - Then i take sheet 1 and sheet 3 and doing some transformations and overwriting the data in sheet 1 and sheet 2 in  my desktop folder.

 

I'm looking for a solution where i want to delete all the records in Sheet 2 and say 'Redundant - No Data Available'  and overwrite the sheet 2  in my desktop folder based on sheet name.

 

Attached the Test Input for the Input Data and Test Output is the Expected Output.

 

Thanks

2 REPLIES 2
HomesickSurfer
12 - Quasar

Hi @suby 

 

Output to overwrite range, and; preserve formatting (optional)

 

Workflow package attached.  Export to C:/Temp to test.

 

Hope you like it.

HomesickSurfer_0-1656425216232.png

 

suby
11 - Bolide

Thank you so much...it works..

Labels